https://www.roadandtrack.com/new-cars/videos/a5238/watch-the...
To really answer your question, I've arbitrarily picked a few common vehicles with metal roofs.
The IIHS says the Civic roof withstands 13,195lbs of force: https://www.iihs.org/ratings/vehicle/honda/civic-2-door-coup...
A Subaru Outback: 18,533lbs of roof strength: https://www.iihs.org/ratings/vehicle/subaru/outback-4-door-w...
A BMW 3 series has roughly the same roof strength as a Model 3: https://www.iihs.org/ratings/vehicle/bmw/3-series-4-door-sed...
An Audi A5 is only 16,327lbs of roof strength: https://www.iihs.org/ratings/vehicle/audi/a5-coupe-2-door-co...
You get the idea!