Its not a bad idea, and not really that complicated.
At night, there is not enough demand for energy, so the grid has to scale down generation somehow. In general, power plants not good nor efficient at doing so, and this requirement affects the profitability of power plants. Sitting idle, they can break down or freeze over, and not be available when needed.
You also have some power which is highly variable, such as wind power, and it can overproduce when power is not needed. Right now its given crazy preference due to green priority, but in a more efficient and fair market overgeneration from wind should push down spot price instead; not force reliable generators to shut down and vent.
Some kinds of plants do really inefficient things, like venting gasses unburnt. But there is no way to operate a grid without them, unless you accept regular total grid outages. There is also no good way to store power, its very much use it or lose it.
So there is a very specific problem, and also an obvious answer: If there was a way to sell the energy at night, at a lower price, to a customer who is very price sensitive, but willing to buy nearly unlimited quantities of power when its cheap, that would give you an ideal power sink for excess capacity.
This ideal consumer of power would step in when prices are reduced because of overcapacity, and step out just as quickly when prices rise, being very willing to nearly completely shut down when prices are high. This ideal customer makes the grid much more stable, and much more efficient to operate. In effect; it gives the power grid a way to convert excess power into an economic good instead of waste.
Bitcoin miners are exactly what the grid needs, on multiple levels.