The only thing that might be right (price fortune telling) isn't the problem you think it is.
Oil prices have decreased over the last 30+ years, with steady increases in overall production until covid.
I'm paying the same numerical dollar amount for gas that I did 20 years ago, for a product that's only increased in quality and regulatory costs (ethanol, refining requirements, safe production costs, etc).
Fracking technology improving is exactly why it exists and has until recently, boomed.
Wells drilled with 1950s technology (which was still the same basic drill, inject, penetrate & pressure as today) are all of a sudden profitable again, because you can re-fracture, and squeeze more from extant wells.
That's improved technology, efficiency, and economics.
>Pushing water through hard rock is expensive and technology isn't magic
Not magic, chemistry. Thats why they let the chemical reactions create pressure. The pumping is to get the figurative vinegar and baking soda down the hole to start the the science fair volcano.
As to markets, if anything public markets are irrationally dumping profitable oil and infrastructure due to somewhat successful intimidation tactics by the environmental movement.
For instance, Shell is selling or shutting down almost all of its smaller US refineries because they're not "green ready." They're giving away profits on a political calculation, not a financial/economical one.