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.
"I had no idea you were so... formidable. " - Anan 7 to James T. Kirk, A Taste of Armageddon