I actually thought Biden's answer on oil was pretty sensible. He said we will gradually transition to renewable based energy sources over time, which frankly is what economics will make happen over the longer term since the price of renewable energy will get cheaper over time while the supply of oil will decline because it's a finite resource. He's not going to and doesn't need to limit oil drilling to make this happen.
The framing of 'destroying the oil industry' probably isn't helpful but yeah. There's far worse issues for Republicans to waste their time on in the next week and a half.
The interesting thing is, regardless of how the public might perceive it, the campaigns/pundits are going to call it a gaffe and a risk. Kendra Horn has already distanced herself from it. In one sense Biden has gaffe'd himself into a position which is... not unpopular?