I would really be just as happy to see the Star Trek franchise end as a film and TV property. Comics and novels offer some potential to do more with it since there are no issues of actor availability and other issues.
For all the talk of behind the scenes friction it came down to the numbers. There has been everything short of gunfire exchanges between Trek production executive since TNG started. That show was horrible until Roddenberry was essentially kicked out by giving him a big office far away from the sound stages. The change in quality was quite distinct. The same can said for a lot of shows. Andromeda had a palace coup and much of the core writing staff that had really created the show from Roddenberry's outline (which was an outer space rehash of 'Genesis II' from the 70's that had almost the exact same continuing premise of rebuilding civilizational, except in a world connected by a global subway [I'm not kidding] instead of interstellar scale. The lead character even had the same name, Dylan Hunt.) were kicked out and everything went to Hell from there. Except for having Brandy Ledford on hand to look cute the entire last season was a confused mess. It isn't being cancelled so much as given a mercy killing.
The Trek franchise has become far too weighed down in continuity issues and its anachronistic origin. On top of this there was little effort made towards overall continuity on the original show and so writers got to drag in their pet concepts no matter how ill suited to the setting. Writers on the later series were expected to treat it all as official history despite the contradictions and plain weird-ass stuff. By the time it came to Enterprise the writers were like time travellers afraid to take a step for fear they'd move a pebble and contradict the already written future.
A big problem was that they attempted to serve the core audience of Trek in such a way that casual viewers, who were critical to decent ratings, got bored or confused by stuff that had the geeks thrilled. And even the geeks were divided in whether they approved every time something with future rerecussions occurred, some went into such apoplectic snits they'd refuse to accept the very existence of the show drove down the ratings even farther.
Too bad, there were great geek moments in that last season. The mirror universe two-parter that invoked elements from no less than three seemingly unrelated episodes of the original series was great. Especially how it was treated as an entire mirror universe Star Trek series, right down to having its own opening titles sequence reflecting the different culture of that world. Tons of fun but much too expensive when so much of the viewing audience was left going WTF.
I'd have liked it a lot more if they'd said, screw Kirk, Picard, and all the rest of them, we're starting from scratch with a show reflecting how people look upon these things almost forty years after the original show started development. They' d be free to make all kinds of references to what went before but also free to not care if they weren't on a path to creating the universe of Kirk, Picard, etc.
Of course, there is one way to see such shows. Look elsewhere than the Trek franchise. Babylon 5 did more for well under a million bucks an episode on a dinky little sound stage near North Hollywood than Paramount has done with far more expensive efforts for many years. I'd rather see a single good writer like JMS and his chosen staff given a reasonable budget with a two season guarantee in advance than another Star Trek anything.