The Energy Transition: Balancing Oil Demand with Net-Zero Goals