Agreed OP, it's worrying. I'm in Ireland where we have a Green party whose only policies seem to be a carbon tax on everything, no real solutions. Added to that we have massive data centres taking up huge amounts of our energy grid. But they bring in money, so the government allow it.
I agree with the frustration of everything having to be automated nowadays, it's all a huge drain on our energy resources. Houses nowadays have far more electrical items than ever - looking round the average kitchen and so many things don't have to be plug in, a bit of elbow grease would do what's necessary. But there is a general trend towards everything being connected, which I find weird. I'm very grateful for technology but it's a blessing and a curse. And in a way it keeps us distracted, so we don't notice the decline in nature around us.
It's interesting that having a small homestead and growing veg, keeping hens etc. is what many of our poor ancestors did, but it's now become the preserve of the upper middle classes who have the space and time to do these things.
I have been worrying about energy/ resource availability for a while, I don't have kids to worry about, or I would fear for their future. I have a dream of being off grid in a little tiny house on wheels (basically a fancy wooden framed, properly insulated caravan that can be moved in case of fire or flood) living with less stuff, and with my own mini homestead. Who knows if it will happen but I will definitely try in a few years when my parents are gone (currently caring for them in their old age). Some solar panels and rainwater collection system, a few animals and a quiet life. Not so reliant on systems that are out of my control.
But as you pointed out OP, renewables are not perfect, however I will take solar panels working for 25 years than none at all. Actually I think they just lose efficiency after that time, so may work 50% or something. But I agree the resources needed to build them is a problem.