I’ve used 9.2 up to the latest versions. Certainly if 9.2 is meeting your needs and you don’t want/need the 2.6 kernel enhancements, I don’t see any reasons to upgrade the underlying O/S. You can also upgrade the kernel to 2.6, if you want to: http://www.linuxforums.org/forum/linux-kernel/11904-anyone-sucessfully-compile-2-6x-mandrake-9-2-a.html
I am curious why you don’t want to upgrade, but that’s your decision. They all don’t affect you, but there’s a lot of vulnerabilities in 9.2 that would be “fixed” in Mandriva 2007. Obviously, you can update all of the packages using URPMI or going about it the hard way.
Besides hating the name change, I’ve seen no downfalls of 2007. I’m using the Free version, so there’s no upgrade costs involved for me and we use MNF2 at work for some firewalls.