Re: Earth based Trek show
How good or bad a show like this would be depends entirely on the characters. When DS9 came out people had the same reactions, who wants to see Starfleet Officers stuck on a space station? But the excellent writing and well developed characters made it work.
And the badass starship and a war with lots of ships shooting lots of weapons at each other...
And it still isn't popular outside a narrow band of Trek fans.
"If I hadn't tried, the cost would have been my soul." - Admiral James T. Kirk, Star Trek III: The Search for Spock