In fact, you can also miss out on some amazing story and interaction by succeeding rolls. Just like real D&D.

One of the things that's so impressive about this game is how well it handles and reacts to the variety of different decisions, succeeses, and failures you can make. Failing a roll in one spot likely just puts you on a different path, with a slightly different story.

In fact, particularly in narrative focused games, failure is just as important, if not moreso than success. How interesting is a story, really, if the characters never stumble or face hardship? It's not nearly as compelling if they succeed at every turn.

Even combat, having to flee with half your party dead is peak DnD. At least in BG3 you can easily revive them.