Rocktar's long post was very good. It was thoughtful and well researched and even included a link. However, I think it overlooks the boost that need gives to ingenuity. We need cars that run on water and sunshine and emit only water vapor as exhaust. Because we need them, somebody will discover how to make the necessary slight improvements in the efficiency of electrolysis.
I would never recommend that anyone learn to code, other than as a hobby. AI is taking all those jobs.