Peruse the forum. There's a topic on near everything relevant you might imagine. If you want a topic starting from a bearish premise, here is one. [1] In general I think there's little doubt that Starship is viable, but the exact implications are open to a wide range of speculation. Prices are going to go down, and payload sizes are going to go up, but the exact degree is open to speculation varying by orders of magnitude.
[1] - https://forum.nasaspaceflight.com/index.php?topic=63166.0