This graph shows the frequency drop we encountered: https://www.netzfrequenzmessung.de/bilder/2020_01_08_Abschal...
The red line at 49Hz is when things actually get switched off for the first time (12.5% of load).
An (imperfect) analogy would be if you and a friend were biking up a hill on a tandem bike. If a third person hopped on the handle bars (or your friend stopped pedaling) the bike's wheels would slow down, assuming you are putting a constant amount of power into the pedals.
Increasing load decreases frequency exactly the same way as anything rotating slows down when you increase load. Electric grid is like chain in a bike. Generator producing power leads a little. Loads follow little behind. They are not exactly matched. Like bike chain is tighter to one direction and looser to other under load.
Mass of rotating generators provide kinetic inertia into the grid so it reacts very little to small variations in the load. But if the load becomes too high and turbines can't speed up, frequency of the grid slows down.
Remember that the A/C power grid needs to be synchronized across the entire continent, so each A/C generator that makes A/C power and runs at 50Hz needs to have the position of a physical object (the rotors) match the position in the current power cycle. If it's badly wrong, you have power-plant sized energy feeds fighting each other — imagine a train wreck, two massive oversized freight trains smashing right into each other. It's like that, but with electricity instead of a physical collision.
This can obviously cause major damage, so once you start deviating from the reference frequency by enough, it's safer to just cut off the interconnects and go offline.
I can't think of any practical way to use that much power all at once either. On a small country size grid with a lot of renewables that can't ramp quickly I could see some foundries pulling it off.
The drop was around ~4.5GW
Though people have hooked up amateur radio equipment to it AFAIK.