It's true that renewables can be highly affordable when the sun is shining but when the wind is blowing but the reason why they work with the current grid is that natural gas is highly available and cheap and the capital cost of gas turbine generators (very similar to jet aircraft engines) is very low.
Hydroelectric can fill some of the gap but at an environmental expense: if you want to support a healthy ecosystem you need a relatively continuous flow in rivers. If it is starting and stopping a lot you are depriving the ecosystem of a valuable service.
The idea that consumers can match demand and supply is also limited in applicability. If you turn off power to an industrial facility like a microchip factory you can destroy days if not months worth of production. Wholesale electricity prices can range from negative to astronomical and it is outright cruel and unrealistic to expect ordinary consumers to be exposed to that.
Options for power storage have improved dramatically in the last decade thanks to the development of electric car batteries but they are still orders of magnitude too expensive. If they follow the same curve solar has they could come within reach but with any setbacks they could remain science fiction.