This citation is an order of magnitude off. The US doesn't really track/release visa numbers well, what you're citing might be the number of individual entries using a TN visa - visaholders go back and forth, it's not the total number of visa holders.
DHS estimates 130k Canadian visaholders in country in 2024. https://ohss.dhs.gov/topics/immigration/nonimmigrant/populat...
Canada has 22m workers, so 130k working in the States is nothing like what you're claiming.
>their entire economy
Resource extraction is about ~10% of GDP, compared to 3-5% in the US and 1-2% in mainland Europe. Scandanvian countries have comparable resource extraction % of GDP. It's hardly the entire economy. It's also diversified resource extraction, it's not dependent on oil, etc. Your claim is overblown.