Nobody was positive about Bush, Bush started the slippery slope Trump is on now, for instance the war in Iraq was wildly unpopular, and the comment that if you aren't with us you are against us was disgusting, considering the war was based on false intelligence, which was reveled already at the time.

Biden was at best a mediocre president, and he too made weird comments like USA will always stand by Ukraine at the same time Trump behaved as a Russian asset, and could possibly win the election. Still Trump has taken it to new lows in everything which even Bush didn't, and USA was also very unpopular after Bush. But Trump is breaking agreements left and right and both politically and economically attacking allies for rational reason. Neither Bush nor Biden did anything remotely close to that.
Trump and Maga is really a new low in USA in so many ways, and even if Trump had a foreign policy of business as usual, he is obviously dangerous for his fascist policies, that would 100% eventually flow over to foreign affairs.

But that besides the point I was trying to make above. You claimed it was mostly about being an export economy competing with China, I think I demonstrated that that is too simplistic.

Maybe the simpler point I could have made is that everybody competes with China.

But how you can even think of comparing Trump with Biden is beyond me, those are so different in almost every aspect that it's ridiculous to make that comparison IMO.
I bet if there's a comparable poll from 2 years ago, USA would have much more support back then.