There are already companies making thermal storage systems to store excess energy. They heat sand up to about 500 degrees when there's excess power and then convert it back to electricity or just use the heat directly for heating water or living spaces.

There's also companies (googles do nothing but link to YouTube videos) working on scaling this down to about the size of a water heater.