Save points are for sissies, my brother never uses them. He lost a bunch of progress once, and was like "Sis you gotta show my how to use save points". I tried to teach him, but alas, he just couldn't. Because save points are for sissies, bros wouldn't understand.
Save points often balance difficulty, or how long you expect a player to be able to play competently. An easy game can have less save points, because it's less stressful to play competently. However, RPGs are largely RNG (Random Number Generator, luck based) games. What this means, is luck plays a huge part in how stressful it is to play. A game like Dark Souls has no RNG, everything is predictable and competent play is solely the player's responsibility. Although a very different game, the first Super Mario Bros game is the same. Nothing is RNG, enemies behave predictably, Frick ups happen because you weren't good enough. However, in an RPG, enemies are unpredictable and Frick ups happen because you're not psychic. How do you reliably know if your opponent will tackle, ultima, or defend against you? You really don't. You can know their move pool, but not what they'll choose from it. Of course, competent play is involved in an RPG, but they usually have save points like an easy game would, to balance for competence and RNG. A hard RPG is going to want some enemy AI scripts (reduce RNG) and enough save points to balance difficulty (because a player can only play competently for so long).
NES RPGs are dated, and come from game developers who were only learning how to make good games in the genre, they were beginners themselves! SNES RPGs are when RPG developers really mastered the art, if you're looking for some retro-inspiration, don't look at beginners, look at what happened when those beginners got good at what they were doing, and became the masters!