A large studio, with a large enough investment, could actually revive the demand for Star Trek game licensing by creating a high-quality Bridge Commander 2.
I had to check this thread wasnt posted in 2006 - Bethesda has had the Star Trek license for a couple of years now. Better than that they have the 
complete Star Trek license, something that Activision never had.
The problem for BC2 (remember that they did make a start on it before Activision spat it's dummy) is that Activision still own the license for the name "Bridge Commander". There is no reason at all that TG couldn't approach Bethesda with a proposition of creating a new game in the style of Bridge Commander and call it something different.
Reasons why TG wouldn't want to do that are two fold I'd imagine. Firstly when they made the original Bridge Commander they had to approach Activision with a functioning demo to prove the concept - that takes a lot of time and capital and still isn't guaranteed to get Bethesda's support in the current climate. 
The other thing to remember about Totally Games is that they haven't focused on PC games in a while, they have been mostly focusing on Mobile games since 2003 - that's not to say they wouldn't go back on that, but why the sudden change of focus?
Overall I don't think its likely we will see BC2 ever get finished (under any name), but if it does I'd be one of the first to buy it. In the meanwhile Im happy to continue development on Excalibur, oh that reminds me...
Excalibur, with a billion dollars to spend on development, could do it. Is it likely? Hell no. In a perfect world with infinite money, would it revitalize Star Trek in a culture where even mentioning those two words can cost friends? Absolutely.
We don't need the money, just time from us and support from Trek gaming fans.