IIHS says:
“Frontal crash test results can't be used to compare vehicle performance across weight classes.… Given equivalent frontal ratings, the heavier of two vehicles usually offers better protection in real-world crashes.”
I've seen the aftermath of a Renault Megane hitting a Ford Explorer, and it wasn't pretty. The Megane was a writeoff, with significant intrusion into the passenger area. The Explorer looked like it had been de-orbited rather than centre-punched by a small hatchback, with the bodywork in four pieces and parts scattered for about 100m. The occupants did not fare well, and indeed none of the small pieces of the occupants spread around fared well either.
Bigger cars are safer, for better or worse. Those Ford F-350s will, in general, survive crashes and protect the occupants better than something like a Toyota Camry.
IOW, it's a market failure (externality).
If you hit a bridge pillar or drive off a cliff, it doesn't matter how heavy your vehicle is.
I'd for these types of crashes it's much better to have a small, nimble vehicle that is more stable and doesn't crash in the first place rather than a huge truck with poor grip that tips over if you corner too fast.