this is actually a very well written piece of excellent data about the really important issues and limitations of our planet. At one point I want to disagree with you: I believe you are too harsh to yourself. Having roof top PV and a powerwall is already a lot you can do as a consumer. And yes, it may be, that humanity will use every single drop of fossil fuels or any pound of raw material left in the soil, but we are also at a fast pace in regards to technology and clean technology development that could really be a game changer. And the current small use of renewable energy and EV (there is now a multitude of studies that shows that EV and renewable energy - looking at the total life-cycle - are already, using the current technology, environmentally better than their fossil counterparts) could help us get that extra time we need for solid state super batteries or even fusion power.
I love your optimism. World needs it for sure! I really mean, and this is not a snark.