It sounds like you're aiming for something a little more advanced, but I want to mention Amazing Tales [1] just in case you aren't aware of it. It does really well as a "first RPG" for kids, with the focus heavily on the storytelling part of the game.

[1] https://amazing-tales.net/