There was a rumour that the last episode of TNG s6 was going to involve the E-D being recalled to earth to be decommissioned and renamed as the 'Queen mary', along the way there was to be a battle, inh which the stardrive is destroyed, and the saucer was to crash land on a planet a la GEN.
anyone else remember this/add anything too it?
CDP
I read somewhere--possibly the "making of" section in the Generations novelization--that the idea was considered. The Enterprise's mission of exploration was to be ended, and she was to be recalled to Earth to serve as something like an official liner in the core Federation worlds, a Starfleet yacht carrying around admirals and diplomats. The Queen Mary was probably brought up as a comparison, but I don't think they were going to rename it. On their way home, there was a battle, the ship would separate, and the saucer would crash a la GEN.