Not to discount your point of renewables having massive issues, they just simply do not compare to the destruction that is caused by getting fossil fuels out of the ground and the damage it does once we start burning it
We have a giant fusion machine in the sky delivering energy in great excess what we use, and we only capture a tiny fraction of it at the moment. We can make each household practically independent. Fission and (hopefully soon) fusion will be good for meeting grid demand when renewables can't, but a distributed grid is simply more resilient to everything, from local events to country and nation-wide disruption of central generation points.