Storing electricity for more than a few minutes leaks a lot of it, no matter how you do it. Unless you're using expensive high-performance batteries, we're talking about at least a third of it gone, either leaked or used to manage the system.

Rooftop solar in particular is generally less efficient in terms of environmental footprint than utility-scale solar. The main benefit is that the physical land footprint is recycled. A secondary benefit is saving a few percent on transmission losses if it's never pushed to the grid. The drawbacks include losing a lot of efficiency from being forced into a suboptimal angle relative to the sun, a larger infrastructure footprint from being more spread out, maintenance in particular being more difficult/dangerous, energy requirements for lifting things to the roof, and some extra difficulty with grid management.

Most places aren't particularly short on buildable spots that are close to the consumers and not far off the ground.