We'll likely have much better technology in the future and the problem will more or less solve itself. In this day and age satellite internet simply just is the most sensible option and probably cheaper aswell. The amount of diesel machinery you'd need to dig all that cable in the rural USA alone would be mind boggling not to mention the enviromental damage of all that digging. These cables don't last forever either. They too need maintenance and eventually to be dug up and replaced.

Rocket is just the delivery vehicle for the satellites. It's not supposed to stay in orbit itself. Building the rocket is what has made space flight so expensive in the past because they were single-use but now with reusable rockets the cost is much less of an issue. They run with renewable fuel aswell - oxygen and methane.

Space travel is going to be getting much more common in the future and the number of rocket launches is only going to increase either way.