I agree with you. It's not all roses and unicorns. There is definitely issues that need to be addressed.
First, and that's the problem with articles like above is they say renewables suck because they have emissions too, so we shouldn't go that direction.
My thoughts about that is that they are in the startup phase of becoming more prevalent. CO2 emitting energy (coal, gas, etc) have been used for 100+ years now. Of course they are established and are well understood.
Renewables are just starting. There needs to be a mix (wind, water, solar, etc) to overcome the problem of time of demand.
That's the biggest issue since that is even more unknown territory.
I believe there is options out there like ex. gravity storage, heat storage, compressed air, etc and of course batteries. Again, we need a mix.
But in the end electricity driven transportation makes the most sense since it can be used easier than fossil fuels.
I believe hydrogen might be a transition fuel on the way to electric in some niche cases. It just needs too much energy to be produced and needs to be transported just like fuel. It doesn't make sense other than maybe (!!) for long haul road transportation.
Just some of my thoughts ... [emoji6]