I think that's more relevant with really large vehicles. An SUV is generally somewhere in the range of 1.5-3 tons whereas a loaded semi truck can weigh up to 40 tons. If a road is designed to handle 40 ton vehicles then i have a hard time believing that 2-3 ton vehicles make much of a difference compared to a 1.5 ton vehicle.

A semi truck with a trailer will distribute those 40 tons over a larger area due to more and larger tires, but I am assuming that it still impacts a larger ground pressure on the road than a personal car - at least when loaded.

It's not so much ground pressure as axle group loading.

You can think of roads as basically retaining walls as they're a hard compacted mass of stuff "floating" in otherwise fairly fluid ground. Sure, high point loads can damage the top surface (not really a problem since anything on tires is fairly low point load) but it's the overall weight you're asking it to bear that causes the pressure to just kinda mush the wall over.

I'm currently in the Czech Republic where the roads are about 100x better than my city of 1 million+ in Canada... No, it's an issue with our government.