This isn't a deeply unpopular anomaly. This is a significant chunk of America, and they may easily regain the majority if the economy improves in a few years (or if it worsens further under a Democratic president).
Trump was deeply unpopular at the end of his first term too, and Americans still went back for a second bite.
We gotta look inward and, metaphorically speaking, go to rehab.
Reducing America to one simple statement is not possible.
American re-elected him, despite the cronyism, jan 6, mental decline, etc. Combined with the democrats are so self defeating and they also repeatedly poked at trade issues (the loooooong running softwood lumber disputes, Keystone XL, "buy American" provisions that ignored NAFTA/USMCA for projects that were going ahead w/o the provisions, etc).
We know what populism is (we've experienced and are experiencing it ourselves) and know that it is usually fleeting, but we don't trust another "smarter" nativist president to come along and screw us again.
Also, there's an internal game going on here. Canada has (institutionally) took the "easy" way out of controversial projects, often due to our proximity to the US. This has meant that when some projects run into a greater than normal amount of political resistance (eg environmental fights against pipelines or LNG terminals), the default has usually been to back off. But Trump has in a way given cover to actually move forward.
I don't expect the next president to "cave" so easily. Even before he was sworn in, republicans had their messaging in full swing against Obama about the deficit. I fully expect the same thing to hammer the next president on trade if they're a democrat.
Current day politics are about polarization. More so than ever. There is no room for nuance. This is what worked for Trump and this is what worked for Carney and the Liberals in Canada. The Liberals didn't win on some brilliant policies they simply won on anti-American feelings.
This is not a statement on who is right or wrong. There are certainly many aspects of Trump's behaviour here that most would say are wrong. The problem is when we lose nuance and debate we can't make progress. But a leader in today's world that introduces nuance loses to the leader that polarizes. Dragging us all down.