Re: (earthquake, volcano, typhoon, sea monsters...).
I see - Page 40 of https://www.heathrow.com/content/dam/heathrow/web/common/documents/company/heathrow-2-0-sustainability/futher-reading/Heathrow_Net%20Zero%20Carbon%20Strategy_v13.pdf
But, this pamphlet is an oversimplification intended for pointy-haired bosses and not engineers; I don't think it's valid to take it as read that they _ONLY_ had generators for "runway lights" - it indeed says "predominantly for runway lights" but almost certainly would include other critical systems such as the ATC control tower, radar, critical IT systems, etc.
My personal theory is that in the hours following the substation failure, this clusterfuck was mainly exacerbated by grid-tie inverters, i.e. power sources such as the CHP, Wind, Solar and Batteries, which in normal conditions would merrily alleviate the load on the grid supply - until such a point as that grid supply is gone, and then they are borked, unable to sync to any upstream grid.
Then while the grid supply tries to come back on, they are unable to contribute any power. This is a microcosm of a major UK-wide issue, i.e. the feasibility of "Black Start"
The electrical engineers technicians would have to isolate _everything_ (including the EV chargers in the car park) until the total connected load was low enough that one single source could power the local grid, and then start up the grid-tied inverters one by one.