When weather is extreme, these fledgling technologies [wind and solar power] step in to save the day.
Tony Seba and others have predicted that solar, wind, battery power systems (SWB power) are going to disrupt everything else, because they are the least-cost solution to the problem.
I believe this to be true. Solar and wind have issues, but adding grid-scale batteries fixes those issues. Grid-scale batteries are expensive and there aren't enough being built, but that's changing rapidly. It may seem slow now but the progress is on an exponential curve.
I've read through this thread and I see that you were being sarcastic when you wrote the above, but I don't get your sarcasm. Solar in particular: if it's a heat wave, the sun is always shining. Can a house have enough solar on it to run air conditioning? Sure. So houses with solar are removing themselves from the problem. Maybe the grid gets stressed by heavy use when it's hot... but solar-equipped houses don't add to the grid load, and in fact should have excess power they can push to the grid to help the grid.
Also, I saw on Twitter, a person who lives in Texas and has Tesla Powerwall said he is a member of the "Virtual Power Plant" (VPP) there and is currently getting paid over $5 per kWh when his system pushes power into the grid during the current heat wave. A VPP is another way that people can earn back some of the cost of a solar+battery system on their house.
(Note that the more people who join a VPP, the less lucrative it will get. Once there is plenty of power to go around, the power company won't have to offer as much money per kWh. It won't be over $5 per kWh forever. It's still a good deal for everyone, even at lower rates.)
So IMHO solar power, in particular, can "step in to save the day" (a bit over-dramatic, but essentially correct).
Another "fledgling technology" is ground-source heat pumps (GSHP). Just like solar panels, it's not a new technology, but it's not really common yet. A GSHP can cool a house very efficiently even in a heat wave.
A GHSP has pipes buried in the ground near the house, under the frost line. In the winter, it can collect heat from the ground; in summer, it can dump heat into the ground.
My wife and I bought a tract house built (with hundreds of similar houses) in the 70's. We remodeled it, and one of the upgrades was a GHSP. According to the diagnostics on my system, the temperature of the water from the ground loop never drops below 40 degrees F (about 4.4 C) in the winter and never rises above 60 degrees F (about 15.6 C) in the summer. Even when it's blazing hot outside, the ground loop is cool, so our GSHP doesn't have to work very hard to cool the house. Last summer, during a heat wave, my system recorded that it used less than 4 kWh to cool the house per day.
At the same time that our GSHP uses 4 kWh per day, our solar power system on our roof is able to make around 90 kWh of power every day.
(In the winter, to heat the house, our GSHP takes 20 kWh per day. Even when it was well below freezing outside, which isn't super common where I live but does happen, our GSHP takes less electricity than a space heater to keep our whole house warm. In the winter, where we live, the solar makes very little power, so we still need to be part of the grid.)
Now, before anyone accuses me of anything: I'm aware that many people are hurting financially and don't feel like they could afford to do what I did.
I have a close relative who lives in Silicon Valley, who recently got solar power. She got a 20-year term on the solar loan, and the monthly payment is low. Her electricity bill dropped so much that she's actually paying less now (solar loan payments per month plus current energy bill is lower than former energy bill). She also had some modern, efficient "mini-split" heat pumps installed; she's using these both for heating and cooling, and when she heats, now she's using less natural gas, and saving even more money that way.
Some people are in such dire financial straits that they wouldn't be able to get a solar loan, but I think the majority of people could get one. I think it will be increasingly common over time.
IMHO, new houses should be built in the first place with a GSHP and solar roof or solar panels. The costs will be lowest if it's designed in and built that way (and especially if a bunch of similar houses are all built one after another in the same place). Then the costs of these technologies will be rolled into the mortgage, and the cost savings from these technologies will be spread over the whole lifetime of the house.
Because of the above I have little patience for the people who say "we should not have air conditioning in houses; everyone should just suck it up and endure hot temperatures, to Save The Planet." My house is a net exporter of power during heat waves, while being cool and comfortable inside.