I would bet that one of the long-term solutions are gonna be locally produced (that is, on the moon) kinetic storage devices like flywheels and weight shafts. You can store a shocking amount of energy in a big old rock lifted up on a cable by a couple hundred meters.