> By and large, we don't store solar energy for use overnight - we store it (or really any energy) for use in smoothing short demand spikes.

This really depends on the amount of battery storage installed. In California we now see battery discharging through to the morning.

https://engaging-data.com/california-electricity-generation/