Diehard Titans fan here:
Moss's talent is certainly welcome, its his ego that worries me. But its certainly going to give defenses a hard time. Who do they put more guys on? Chris Johnson, Randy Moss, or Kenny Britt? Then, once he is healed, you have to worry about the highly mobile Vince Young who can run just as easy as he throws the ball. When the Titans play the Dolphins in 2 weeks all eyes around the NFL are going to be watching that game.
But this will be an interesting bye week for the Titans. They have to get Young healed and get Britt healed along with introduce Moss to the Titans offense. The Titans practice bubble is going to be a busy place for the next 2 weeks.