I'm also looking forward to commanding a Titan (great asset), but I'm especially looking forward to fighting one (great challenge). The Titan will present another interesting level of threat management.
Every time I think of the Titan, I envision two of them locked in battle. It would be epic to see several fleets engaging one another, with strike craft all over the place, fighting in the shadows of two or more huge, high armored and heavily armed warships, unleashing wave upon wave of ridiculous firepower on one another. Tactically, it will be a great toy, strategically, a great challenge, and theatrically, an epic part of a large scale assault.
As others have said, I hope it can be turned on and off, because there may be days when I only want to contend with traditional firepower. However, if they don't include such a switch, no big deal.