It was just as obvious a hundred years ago that horse manure piling up in city streets was just going to keep getting worse.

we can all agree that it's a non-renewable resource which will not be around forever

True but irrelevant. The oil supply is finite only in physical terms, not in economic terms. It is possible to extract an unbounded amount of value from a bounded resource. All you need is an increasing price, which happens automatically as supplies decrease, and which provides an incentive for substitution. I'd happily take a wager that humanity will transition off petroleum long before we "run out" of oil.