In the absence of a poll about a policy that few people are aware of, it might be relevant to bring up the history of this relationship in order to guess how people would feel about it if it became a hot issue.
Basically, President Carter brokered a deal with Egypt and Saudi Arabia whereby they would refrain from military or foreign policy attacks on Israel in exchange for very substantial military sales and support for both countries. The basic relationship has produced almost five decades of stability in the region.
This can be construed as pro-oil wealth, as pro-Israel, a positive relationship with Muslim countries (not based upon Donald Trump's business interests), and in the case of Egypt for most of the period, as support for a secular regime over an Islamist one. Stability is also a good thing after multiple wars in Asia that are winding down.
On the other hand, attitudes towards Saudi Arabia have soured as it is seen (at least at the unofficial level) as a source for global radical Islamic terrorism, was the source of most of the 9-11 hijackers, continues in an era where public opinion towards oil resources is very partisan, and has been a lot of money over a great many years that may have run its course. Americans on the left and the right are also more aware of human rights violations in Saudi Arabia than they might have been in the past. U.S. involvement in Yemen has also not been terribly popular.