The tool that you use is not that important when making a game. Some years ago someone created tic-tac-toe which can be played using pebbles and sticks.
I used RPG Maker many many years ago, so not sure what has changed since then, but one thing I remember is that games made with it are fairly similar with each other. Sure it offers a lot of tools to flesh out your own story, and your own characters, but the gameplay itself is (was?) difficult to change.
That’s not to say it’s not possible to make something fun with it, but more like it requires more creativity on your end to pull it off.
So no, your project will not automatically fail because it is using a specific tool. Tools just make different options easier/harder to add.