I don’t think smaller trucks get the same level of hate.
You pick a reasonable compromise and arguably a full-size truck is overkill for many but a Mazda Miata is probably too small for a lot of people even if it largely works for a lot of day to day stuff.
So, sure, I could pay for a delivery or rent something from Lowe's if I needed to for a specific purpose but I routinely use my mid-size SUV for weekend trips, transporting a canoe, picking up construction supplies, and the like. I need a vehicle in any case and it makes sense to own a somewhat larger one than I really need day to day to run to the grocery store, especially given that parking isn't an issue and my gas mileage really isn't bad.
If one actually lives in a city (which I don't), renting a vehicle can actually be something of a hassle on a weekend based on what I saw people go through when I was in a ski house after school.
I did also have a smaller car as well when I did more shorter regular local drives but I really don't do those much any longer other than very local drives to the grocery store or nearby hiking trails.
Personally I have a mid-size SUV but if you regularly need to transport around a lot of people, minivans seem more practical in general than a lot of the big SUVs.