Sadly, it was not to be, thanks to the decision of the then-head of Paramount Studios, Stanley Jaffe.

Could it have failed? It’s possible, I grant you. Still, I can’t imagine such a thing not attracting loads of tourists for at least a few years. Even if it had to eventually be demolished, they could have sold bits of it for souvenirs. If said demolition could be made to have more fire and smoke than usual, the resulting charred pieces could have been specially branded as recovered from the debris after the Genesis planet exploded. It might have even made the Earth-bound drydock in JJ Abrams’ reboot seem a little more canonical, but I’m not going to fault anyone for not seeing that far into the future.

At least I got to visit the Star Trek Experience once or twice before it was shut down.