My experience with SUVs and pickup trucks is based on owning an ancient (1993) but capable Chevy Suburban and occasionally driving F-150s at work. Plus I had a brand new F-150 to myself for three weeks while my company SUV was being repaired from a deer using it to commit suicide.
Where I live now, pickups are a thing mainly because the economic base is agriculture. People here tend to use pickups in a functional sense moreso than in the central Rockies where I used to live.
As others have said, secure, weather-protected storage is a huge difference. And hauling 2-3 x per year is easily handled by renting a pickup. Or borrowing one. Or having the stuff delivered.
Not sure where you live, but my observation from living in serious snow country is that an SUV is almost always better in snow than a pickup, given the same drivetrain, tires, and driver. Weight distribution and rear traction seem to favor the SUV.
Also not sure what type of off-roading you’re interested in, but based on my off-road experience of seven or eight years ago, I’d choose an SUV over a pickup for that as well. Again, weight distribution and traction. FWIW, my Sub did pretty well in southeastern UT and northern AZ, but my Jeep XJ did far better in more challenging terrain. And a good buddy of mine had a pickup which we took off-road quite a bit, and it did fine, most of the time.
Then again, some people prefer pickups as their daily driver, regardless of functional need, because they like driving a pickup. I certainly get that. I happen to like my four-door sedan, very much, even though nowadays I rarely have more than one passenger. Not strictly practical, but I believe that a person should drive what he or she likes, within the limits of affordability.
Some people see vehicles as mere transportation. Personally, I enjoy the hell out of driving, and like having a car that’s fun to drive. Smiles per gallon, and all that.

So I tend to resonate with what someone on a car forum said: When you park your car, if you walk away from it without looking back at it at least once, you are probably driving the wrong car.
Goes for pickups and SUVs, too.