Re: TNG: Silent Weapons by David Mack Review Thread (Spoilers!)
Titan is the exploration series in the 24th century. Would you really want to give that up? Voyager is the only other 24C series not primarily dealing with the Typhon Pact.
It is noteworthy that without Titan only live action relaunch series remain.
And you don't have to kill the ship to get the characters someplace else (e.g. Tuvok fetched from Voyager).
But blowing up Titan is likely the biggest bang they have left outside destroying the Enterprise.
"You know. 1966? Seventy-nine episodes, about thirty good ones." - Phillip Fry describing Star Trek, Futurama