With the Strait of Hormuz again a flashpoint, investors are betting on domestic oil supply, reshaping the global oil narrative beyond OPEC dominance.