If you invent a battery that is 2x as large and heavy as current vehicle batteries but half the cost, then you might think you would be able to sell them for stationary storage, but you are then competing with the price of second hand vehicle batteries which may well be half price already.
On the one hand, you're right that for different applications having different metrics can be acceptable. Sure, a battery for your home that never moves can be heavy and large and that's okay.
But then you have to consider the economics of production. How many of those batteries will you make? What will the factory for them cost to build? And what would it cost instead to just make a bunch more Li-Ion batteries at the existing factory instead?
There are also different performance profiles within EVs, where different tradeoffs might make sense. Though, like you, I'm somewhat skeptical that any non-lithium chemistries will break through in that space.