as in it's only worth doing if you have nothing else to do with the energy (like when you have too much wind/sun etc)

That's just the concept of energy storage. And even if we lose a significant fraction it's often not an issue given how cheap solar is.

Sure, but it would be better if we had more efficient methods of doing it.