Well, I don't know specifically whether there will be more activity in the near future, but I think there will always be a market (an admittedly small one) for a program where one person can sit down for a week and make an enjoyable (or not) hour-long game.
It is a pretty simple program, but that's kind of the point in my opinion. Certainly, where it comes to making very high-quality games, there are a lot of better programs out there. However, I like RPG Maker a lot primarily because it is very simple and you can do everything that needs to be done yourself or else by relying on public resources. For someone who is primarily interested in one or two aspects of game design (like just story and game mechanics, for instance), I think it's a lot of fun to just have a very simple program where you don't have to worry terribly much about all the artwork, scripting, etc. that you can't do and just focus on the stuff you like.
Some people try to get really fancy with RPG Maker and make some massive epic with custom scripts, art, etc., and maybe there are better programs out there for people who want to make something really unique or amazing. For me, RPG Maker is first a game and only second a game-making tool; the point is primarily just to have fun using RPG Maker, and you can do that just by focusing on the aspects of game design you like and are good at and it doesn't really matter whether you ever get a finished game.
Now, it can be great to focus on the end-product too and there can be a lot of joy in creating a fun, finished game, but not if it comes at the cost of focussing on all the aspects of game design that you don't enjoy.
And all of the sharing of resources is really great too, since it gives people whose talents do not primarily lie in story-telling and game design to see their music, scripts, etc. incorporated into a fun, nostalgic kind of game.
Not that Degica is paying me to write this or anything. No siree!