We're never going to stop using petroleum (for fertilizer, plastics, other chemicals, etc.), but hopefully we'll stop burning it for fuel. While marginal sources like tar sands could likely never be used, the rest will most likely be used for something. Unless there's some revolution in Genetic engineering that lets us make all of these useful products from microbes.