But non-sustainable pricing is very different from "cataclysmic collapse", and too many people expect the latter for too many things, which is just not realistic in my view (and historical precendent makes a strong case against that assumption, too).
A society where water prices gradually increases to "reverse-osmosis only" (instead of "pump-from-the-ground-everywhere") levels is very different from a society where water suddenly runs out.
That's a classic example of the "preparedness paradox" [1]. When no one raises the alarm in time or it is being ignored, resources can go (effectively) exhausted before alternatives can be found, or countries either need to pay extraordinary amounts of money or go to war outright - this has happened in the past with guano [2], which was used for fertilizer and gunpowder production for well over a century until the Haber-Bosch ammonia process was developed at the start of the 20th century.
And we're actually seeing a repeat of that as well happening right now. Economists and scientists have sounded the alarm for decades that oil and gas are finite resources and that geopolitical tensions may impact everyone... no one gave too much of a fuck because one could always "drill baby drill", and now look where we are - Iran has blasted about 20% of Qatar's LNG capacity alone to pieces and blocked off the Strait of Hormuz, sending oil prices skyrocketing.
If you had made predictions/scenarios in 1850 based on Guano deposits running out within a decade or two, you would have mispredicted completely, because a lot of the industry just transitioned to sodium nitrate (before synthetic fertilisers took over). Nowadays media landscape would've gladly made such doom-and-gloom predictions for global agriculture back then.
I completely agree that quickly depleting reserves often indicate non-sustainable pricing for ressources (which is obviously bad long term), but that is very different from sudden collapse.
Yes we can run out of oil, but nobody really knows if or even when that will happen. Right now I'm guessing we won't run out because wind and solar is so much cheaper for most purposes everyone is shifting anyway - this will take decades to play out.