Absent from your analysis is the risk presented by global warming. Obviously, transitioning the energy sources for an entire group of nations is risky and absolutely the kind of thing you expect to be a bumpy ride. On the other hand, uncontrolled global warming is far more risky - at worst, the energy shortages present a limited economic challenge. Global warming presents an existential challenge at worst, and an unbounded, extreme economic challenge at best.
The issue a lot of people have with fracking is not just the local environmental damage, but also the deeper issue of whether it's worth pouring investment into an obsolete industry that is going to produce inputs for other obsolete industries, all of which are environmentally damaging on any scale, just so you can gain a bit of energy security in the here and now. It's not just kicking the can down the road on your future energy security - it's also pushing us towards an extremely chaotic and difficult future for everybody.
They are other important uses hydrocarbons other than energy production. So calling them obsolete seems a bit of a stretch.
For example take coal one of the dirtiest fossil fuels. Steel plants making carbon steel steel need to convert that coal into coke. Even an electric arc furnace needs coke to make carbon steel.
Similar things with other hydro-carbons. So its not like we are gonna stop using them even if the grid was entirely renewable and nuclear.
Now industrial processes that use such hydrocarbons to produce useful stuff other than energy are certainly a minority of the market. So mines and wells for such things will still exist. So the tech is still useful, but we just ideally stop using these hydro-carbons as fuel.
You need a little bit of carbon to make carbon steel, but the vast majority of the coke is used for heat and producing a reducing atmosphere to reduce the ore. Both of those can also be done with a process using Hydrogen.
He sort of has a point in that there are some products (plastics, etc) that are only produced from crude oil. The problem is it's pretty doubtful that fracking would be worthwhile if that was the only demand - there's more than enough normal crude to produce plastics.
As I understand it, most fracking isn't even profitable right now - it is only profitable if oil prices are relatively high.
The issue a lot of people have with fracking is not just the local environmental damage, but also the deeper issue of whether it's worth pouring investment into an obsolete industry that is going to produce inputs for other obsolete industries, all of which are environmentally damaging on any scale, just so you can gain a bit of energy security in the here and now. It's not just kicking the can down the road on your future energy security - it's also pushing us towards an extremely chaotic and difficult future for everybody.