Even with public support this isnt something I’d expect to see in my lifetime, this would be a huge undertaking, a milestone for a more advanced civilization in the future. I’d compare it to space travel, something that was figured as theoretically possible long before it was even attempted. It was a massive effort, but it was possible and was achieved and now many many decades later its having practical applications for things like satellites. But Musk has put it into a bit of a dark age, where its disregarded as a meme and so wont be seeing any advancement for quite some time.