To be fair the genocide of Palestinians didn't start a month ago with Trump, it has been going on for almost 8 decades and all US presidents have supported it one way or the other. So what Trump recently said is not even new, that has been the plan ever since the terrorist organization named Israel was created. Trump is just delusional enough to think his words/tweets change anything in real world!
As for the relationship and your poll question, it is more complicated than that. US regime sees Israeli terrorists as its proxy that is used to further its plans in West Asia including destabilization so that they intervene militarily and occupy energy rich regions and steal the oil and gas like what they have been doing in Syria and Iraq over the past ~20 years.
Meanwhile the Zionist terrorists have been using US like a parasite does and treat it as a host that has to continue feeding them to ensure their survival. This is how they see Americans not just the president:
Over the years, the Israeli leader has developed a reputation among the staff at the U.S. president’s guesthouse for bringing special cargo on his trips to Washington: bags and suitcases full of dirty laundry, according to U.S. officials familiar with the matter.
"The Netanyahus are the only ones who bring actual suitcases of dirty laundry for us to clean," said one U.S. official,....
"After multiple trips, it became clear this was intentional."
In other words the head of this terrorist organization has been intentionally humiliating Americans for many years while taking billions of dollars of American taxpayers money every year...
And the most important point is "occupy energy rich regions" There is an estimated
one trillion cubic feet of gas off the coast of Gaza!
I believe that the absolute devastation we have witnessed in Gaza has been the final
push to sieze more land and secure those gas fields by Israel with the US in support.
Trumps lame excuse of creating a better place and the "Riviera of the middle east"
is just glossing over the destruction they have created. much the same as
Christianity was a cloak for the resource stripping by the imperialists of centuries past.
Trump is an imperialist, he views Canada, Greenland, Ukraine, Panama and Gaza
only as banks of resources which are needed in his plans for MAGA.