https://www.fingrid.fi/sahkomarkkinat/sahkojarjestelman-tila... shows a roughly +1GW (~12GW -> 13GW) rise in consumed power during the first two hours after the price hitting the negative pricing floor (-500€/MWh) at 15:00. Seems like there's some consumer elasticity there, but not enough to make the grid fall over. This is after the national grid operator planned to intervene as necessary and imposed some restrictio…
The frequency of the system is a clear signal about the demand/load match, and if it starts to drop more below some threshold of deviation, loads get disconnected from grid branches.
Of course there can be "interesting times" leading to cascading processes in the multiple interacting automatic failsafes, you can read up on post mortems of grid failures about what kinds of things can go wrong, eg https://en.wikipedia.org/wiki/Northeast_blackout_of_2003#Seq... .. which is why really want to preemptively do the controlled rolling blackouts instead.
The grid falling over would result in a harder, more uncertain and lengthy "black start" process, since plants need power to restart. See eg https://practical.engineering/blog/2022/12/5/what-is-a-black...