I am about the biggest advocate for moving away from fossil fuels as there is, but it certainly isn't going away in our lifetimes. And even in a world where 0% of fuel comes from fossil fuels, we'll still need petroleum for other uses.

A lot of people are thinking like you, and far fewer people are studying petroleum engineering (there is also a negative social stigma), which is leading to a shortage. It will probably lead to even better job prospects for at least another generation.

https://energyfuse.org/petroleum-engineering-enrollment-is-i...

My freshman year I was aiming to enter the engineering program, so I could be a petroleum engineer, for the reasons above.

I took an intro CS, and that changed everything.