I just do not see it. RPGs in computer games will probably last longer and that kind of gaming will get better as the games get more immersive and more complicated.
People will keep writing fantasy, Sci-fi and other kinds of books
And as long as computer games are out there, or there are books to be read, they will keep interest in pen and paper ones alive.