The trailer takes up space when not being used, the back half of the vehicle does not. This is true no matter what the parking situation is. Zero space is better than any space, if the back half of the vehicle doesn’t need to be enclosed or have seating.
The trailer requires some extra maintenance too. Keeping things oiled, tires aired up and replaced regularly. Driving with the trailer means needing to use to parking stalls when parking. Backing up with trailers is a lot of fun too!
The trailer is a very situational benefit for situations where the main vehicle space is needed. Hell, if I need a trailer I can just rent one from UHaul. But I don’t when the same thing is solved with a truck bed, and the truck bed format is far more convenient if the vehicle with the bed is the same size as a normal car!
There are light trailers that can be stored vertically to take very minimal space and can be deployed in a few minutes of effort.
The maintenance costs and effort of greasing two bearings and tire replacement is still far, far, less than the total cost of owning and insuring a pickup truck. Plus, they have the bonus of being a whole lot easier to load and unload due to the much lower bed height.
Any place you might go with your trailer to haul larger/heavier items will have proper room to park your vehicle and small trailer. After all, they are getting far larger trucks and trailers to receive and ship items in bulk. Appliance, home improvement, furniture stores and the like seldom have “street only” parking. And if that’s all that’s available, you didn’t need either the trailer or a pickup truck to shop there.
Backing up a trailer isn’t hard - learn to drive.