I wouldn't like to see it as a new series but it certainly looks fun as a piece of Star Trek related film.
I agree to a certain extent regarding the apocalyptic bent that many shows and films go down these days, I wouldn't like to see it as a major theme of a Star Trek show. To me it would be missing the point of an optimistic future and almost cheapen the 40+ years of strong, good characters doing everything to preserve their future and show that it's worth fighting for.
I may be opening a can of worms here but why don'y you like Battlestar Galactica?
I very much enjoyed Conspiracy at the end of TNG season 1, I really wish they'd followed that up. I can't put my finger on why exactly but what they did there felt much more of a threat than other coups and potential takeovers that were offered in later seasons and shows. It could have been really effective to have had Admiral Sati in The Drumhead referring to that as part of the threat to give her accusations a bit more backing