Supersonic passenger flight is happening. Boom Supersonic is building their (crewed) subscale supersonic demonstrator right now. They hope to pick up where Concorde left off (but much more efficient and slightly faster and more granular, enabling more routes).
NASA is building a low-boom civil supersonic demonstrator (also crewed) that will demonstrate sonic-boom-lowering techniques to enable passenger supersonic flight over the continental US.
There's lots of room to improve these things still. And I'm excited still about lithium battery tech. It's the internal combustion engine of our century and its consequences are perhaps even more far-reaching. The theoretical useful energy of the most advanced versions of this, the lithium-air battery, are on par with that of hydrocarbon fuels, so by the middle of the century it's likely we'll have completely clean civil supersonic transport with low acoustic emissions as well.
I think we still have a very long ways to go to advance technology. Vacuum tunnel maglev trains allow higher efficiency than even conventional rail but without an ultimate speed limit. They could operate at hypersonic speeds in 100 or 200 years from now, with the energy recouped regeneratively at the end. That makes efficiency orders of magnitude better than today's passenger air travel with speed increased by an order of magnitude.
I think ultimately in the further future, if you want something exciting it'll be:
Further urbanization of everything, so humanity concentrates in opulent metropolises well-connected by ultra-efficient transport. Food production increasingly goes to single celled organisms, freeing up space for rewilding of the Earth and healing of the ravages of industrialization while individual well-being is far greater. Human economic expansion in space is technically unbounded. The solar system allows access to many, many orders of magnitude greater energy supplies without an impact on the Earth's ecosystems. Things that can tolerate latency, like high performance computing will leave the planet to access unlimited energy in space (Moore's Law coming to a slow end will actually enhance this transition as you can afford to amortize the hardware over long enough periods of time for this to make sense).
Musk's spaceship is just a taste of what's possible. Improvements in efficiency in even chemical rockets (by reducing structural weight, fine-tuning Isp over the mission cycle, using hydrolox near stoichiometric to enhance performance) can reduce cost of space travel to about what long-haul passenger travel currently is.
I think things will continue to improve. And these are only the foreseeable things. The actual future will contain many unforeseeable discoveries.
None of this is guaranteed, but it can be ours if we so decide to make it thus.
A vision of the future beyond the Earth in the timeframes you mention: https://vimeo.com/108650530