The demand for oil will likely never truly go to zero; too many products (outside of energy generation) rely on their byproducts.
As for the bigger picture — yes, higher prices for oil might spur extraction in regions outside of the middle east, but that's a local only viewpoint. Globally, higher oil prices reduce consumption and make green alternatives more attractive on net.