Back to the original subject of SxS vs Compact Truck...
Newer small trucks like my 2021 Toyota Tacoma can hardly be called compact. It's nearly as big as a 1/2 ton from the 70s. If we really want a compact we either have to go back to the 80s/90s or start looking at the newer trucklets like the Ford Maverick or the Hyundai Santa Cruz. Neither the Maverick or the Santa Cruz have any heavy duty parts - they are both unibody construction like cars, and only the Maverick has any off road ability. And that only comes with certain trim levels and options that get locking 4 wheel drive and increased clearance.
The older compacts like the original Toyota trucks, the Nissan Hardbodies, the little Rangers and S-10s, are pretty much all used up or rusted out by now. They're mostly underpowered and the Rangers and S-10s were pretty unreliable when they were new, let alone now.
All around, a truck is more useful for 99.9% of people. But if there's any reason why a truck can't handle the terrain a SxS is just about the only other option, IMO. I have the Tacoma just because I use a truck for outdoor activities or for hauling stuff now and then. I could really get by with a small or midsize SUV. But since I have a choice, I choose the Tacoma. It's easier to handle in traffic and park than a full size, I can tow 7000 pounds if I have to, and it gets slightly better MPG. It does great on muddy or snow covered fields so long as it isn't bad enough to get me high centered. It's definitely the best choice for me. But I'm not on mountain slopes trying drive between pine trees and boulders. That's where the SxS will truly shine...