Unfortunately, that isn't likely to happen. Netanyahu has, to date, handled Trump deftly and Rubio's current presence in Israel seems to be aimed at offering support to the ground offensive, not opposition. I honestly have no idea what kind of backlash it would take to shake U.S. support for this genocide.
It is worth noting that Andrew Cuomo, in a desperate last-minute gamble to boost support in the NYC mayoral race, has come out against Israel. Considering that much of the attacks on Mamdani have focused on his support for Palestine (construing him as antisemitic), it's notable that other candidates also seem to think that being anti-Israel is actually the vote winner for moderates right now.
More worrying for Israel is that it's becoming a partisan issue. That goes to both ends - previously unthinkable, unwavering support under Republicans but a very short leash under the Democrats.
A highly salient political issue becoming partisan is a good thing in a representative democracy, as that is the only thing that makes it possible for the public to influence it by general election votes.
Every possible alignment of circumstances “backfires” in FPTP because FPTP is a fundamentally bad way to elect a legislature.
That’s not a problem of, e.g., salient political issues becoming partisan—representing a coherent position on salient issues is the only useful thing parties can do—it is a problem of FPTP.