Hmm, the most recent turn-based rpgs on consoles like the PS3 and XBox 360 I remember playing were Lost Odyssey and Resonance of Fate.
But yes, they're definitely still going quite well on the 3ds. I heard Child of Light was going to be Turn-Based, so I'm looking forward to that...

Personally I hope turn-based never dies out. That would be sad.