Next Honda product due for an overhaul is the Accord for MY 08. My guess is that you will first see a 6 speed auto with the Accord EX V6.
BTW, SH-AWD and 295 hp is the current RL. I doubt you'd see the TL encroach on RL territory. I'll bet it remains front wheel drive only, and maybe 270 hp. But that's a long way off. Who knows what will happen by the time the TL is due for a redesign.