Depends on the tradeoff. The tl;dr of the article is that there's a tradeoff between pressure and efficiency. You can store at higher pressures in smaller vessels, but it's much less efficient. Low pressure (larger vessels) can be extremely efficient. In between, there are hacks to increase efficiency using heat exchangers and the like.
Beyond that, this is being pushed in the article as a rural/off-grid approach. For urban residential, it makes a lot more sense to centralize storage and run houses off a regular grid, than to try to make each house an independent entity.
In the medium run, we need to shift the grid itself from the current baseline+peak model to a solar+storage model (rolling wind into this), with distributed metering on the storage grid. Capture solar/wind power when the sun shines and the wind blows, and sell it when consumption outstrips supply, with pricing set dynamically on a distributed network.
Once you have that, for on-grid purposes, we'll probably see a diverse world of storage - car batteries, compressed air, industrial battery sites, water storage, thermal storage, etc.