Despite the OP's angst toward MMORPGs, that's one important plank of the future. They will get more sophisticated and offer a more finely tuned experience for individuals, both through more pervasive instancing (most MMORPGs already have the ability to let people go into a dungeon all by themselves, as opposed to the dungeon-as-mall-at-Christmastime that early UO and EQ1 pioneered) and through more products like NWN and Second Life that allow user-created content.
At the same time, games like Pokemon Jr. will become more prominent as the industry (rightly) pursues new blood.
Games with a more adult focus, like World of Darkness and lots of the indie games, won't be going anywhere.
OGL games, now that the genie is out of the bottle, are unlikely to go away, especially as "the world's most popular roleplaying game" is going to remain compatible with OGL, if only to keep gamers from freaking out because 4E is 100 percent incompatible with 3E.
Hardcore RPGs like HERO are probably going to get squeezed pretty badly, though.