Of course, the mistake Paramount made was ending TNG in 1994 and starting Voyager instead. They should have treated it like any other procedural show, which is effectively what it was. It's a ship, have a revolving door cast policy. Stewart wants to move on? Cast a new captain. If someone wants to leave, or the producers want to write them out, fine.
You keep the essential spirit and brand recognition of the show intact, and give it more longevity and potential for renewal. Don't go all Stargate with numerous diluted spin-offs which can only confuse people. I'll just pop in my time machine and tell Sherry Lansing.
I agree... they should have just kept making Star Trek:TNG and changed the crew, leaving the original TNG crew for the films.