In a power station there is some one to make a decision to turn off or not, but with wind and solar it has to be all automated, so when some thing goes wrong, and voltage drops to under 207 volts per phase, instead of trying as hard as it can to bring the voltage back up, it just gives up and switches off, often needing a manual reset.
So we get the domino effect.
And likely it needs much more power to be able to get it all running again.
I had it to a smaller scale on the Falklands, I was looking after 4 generators, 250 kVA each, we needed at least 2, but rarely needed 3, but we had a problem with fan belts, the governors on the RR engines was electronic, and acted fast, which caused the fan belts to break, this cause engine overheating and it would auto shut down, I would see lights flicker and run to generators, they were still running but under speed, because under speed they could not produce enough power to trip overload, so sitting their at 40 Hz and exhausts glowing red hot, but I could not put on another generator until Hz back to at least 45, so I had to shed load, so quickly opened on breaker, then put on a replacement generator, share the load, then put that breaker back on.
I got into trouble as I had switched off office supply and it seems they had not realised the dip in lights likely would mean loss of power and they needed to save and log off. But point is I had to decide who to switch off, and quickly, so it was the first I came to. Had I not switched some one off, all power would have been lost.
Even with just 4 generators it could take 1/2 hour after loosing them before I had finally got everyone back on, ensuring load was shared each time more load was added. How long it would take with the national grid I don't know.