Last time I did the maths based on data from gridwatch the storage capacity required dropped dramatically if you over built the on the production side.

But ok, 30 million homes, 100kWh storage each, that's 3000 GWh

A 100kWh battery is about £25k, less than 1/10th the cost of the house, and less than the average new car

That doesn't seem unrealistic.