When I'm playing an RPG, there are several things I'm constantly watching for.
One of these things is irreversible events: occurrences that block off alternative actions I might have taken or prevent access to alternative content I might have enjoyed.
I don't like them. Mostly.
Imagine a single path between two areas. The path leads to a collapsed ledge. You jump down, then find that the path above is too far up to reach again.
Another example: imagine crossing a bridge over a wide chasm. Every place you've visited so far can be reached again if you stop, turn around, and go back. Instead, you cross the bridge, but as you reach the far side, the bridge behind you crumbles and falls away. You're now stuck on this side; there is no mechanical means in the game by which you can return to the previous side. None of those areas can be reached now.
Yet another example: you're creeping through the dark when you hear a chitinous rustling somewhere ahead of you. You don't want to make a light, but you have only one potion of Night Vision remaining that you wanted to save for later. You decide it's more important to stay hidden, so you quaff the last Night Vision potion and carefully evade the nest of spiders now visible. Later, you can hear multiple skeletons clattering in the dark ahead. To avoid running into them, you must make a light. The skeletons see you and attack, forcing you to enter combat instead of enjoying being sneaky.
One more example: your character is having a conversation with another character. You're playing your character as cool and smart, trying to keep future dialog options open with this other character. But in clicking on a speech option, your finger slips and you choose an aggressively physical response option. The character you were talking to gets angry at you, walks away, and will no longer talk to you for the rest of the game. Because the developer provides no way to reload from a recent save, you're faced with the choice of either losing hours of play or missing out on what might be a fun interaction with an interesting character. (In a visual novel you might just replay the whole game to see the "missed" content, but let's say here that this interaction was just one small but interesting part of a much larger RPG.)
What irreversible events such as these have in common is that they foreclose options. Where prior to an irreversible event there might have been 100 different things you could choose to do, after such an event there might be only 50, or 3, or just one. The opportunity space for fun has been shrunk.
Certainly not everyone will find this objectionable. I do, because an important source of fun for me in a game is having enough space for cleverness. I'm having the most fun when a game enables and encourages surprising-but-effective choices or creative combinations. When instead a game is designed such that there's only one (obvious) solution to each problem, or in which a mere handful of worthwhile mechanics exist that can't be combined, there's little opportunity for cleverness. You're mostly just being marched through the developer's predetermined story.
That, to me, is not a mentally interesting game. It may be an exciting experience; it may be a moving experience; it may be a low-stress way to pass some time. But it's not the most appealing kind of fun for me, and, I think, not very appealing to gamers like me who prefer interactive entertainment that exercises our brains as well as our hands and our hearts. Irreversible events decrease choice. And for some gamers, less choice is less fun.
I think there are exceptions to this. As noted above, not every game has to emphasize thoughtful fun. It's fine that there are games offering other kinds of fun. It also might be possible to offer too much undifferentiated choice, such as from a combinatorial system that lets players bang together hundreds of inputs to yield millions of possible outputs (although here I would argue the true design flaw is the "undifferentiated" aspect). And of course I'm not actually all that grumpy about consumables such as food or potions. Consumption as a one-way process does foreclose options, but as an economic phenomenon -- a value choice -- this is often a pretty useful way of increasing the consequentiality of player choice, which is itself a worthwhile design goal.
Foreclosing on personal interaction options with characters is trickier, but I can appreciate the argument that "this is how conversations with people actually work." I'm not sure this is a strong argument for an RPG, though -- at least, not until better AI allows NPCs to respond plausibly to surprising inputs from the player, rather than just following pre-written branching logic no matter how narratively bizarre and mechanically undesirable those character reactions may seem from a player's perspective.
More importantly, story beats in general will usually need to be one-way. It would be extremely interesting to find a game that's designed -- not just by implementing save/reload, but through a first-class gameplay mechanic -- to allow the player to backtrack to any previous story events to explore different alternatives! Short of this, it's pretty reasonable that once the player has triggered a plot point, then short of reloading a savegame there's no going back from that story event or its directly related consequences in the game world.
(This points out an interesting difference in the kinds of irreversible events: events in time, and events in space. Irreversible events that lock off currently existing physical or systemic spaces are IMO a Bad Thing for exploratory fun; irreversible events that occur sequentially in time are, in virtually every case, necessarily OK as one-way processes because that's usually how story works. There's probably a better way to express this idea; I hope at least the basic thought is understandable.)
Overall, then, with the exception of story beats it seems to me that a pattern of implementing or allowing irreversible events -- consequences that reduce opportunities for player choice -- is a big red flag for exploration-oriented gamers. It's a warning that the developer is not actually committed to supporting player freedom and creativity in overcoming challenges and exploring the game world's content, but instead wants to tightly control the player experience.
Conversely, it is a thrill to discover a game that visibly minimizes irreversible events, that I can see has taken pains to ensure that I can almost always backtrack to any location or non-story state. When I play a game that's careful not to foreclose my options, I know it's made by a developer who is confident in the high-level flow of the game, who is genuinely delighted when I discover a new (preferably non-game-breaking!) way to interact with the game world, and who respects my fun-finding autonomy.