If consistency is your issue, then live up to it. be consistent and hold ALL games to the same standard/logic to which you’re applying to Uncharted, then you’ll realise that ALL games suffer from ludonarrative dissonance in one way or another.
Why? All games are different.
Uncharted tries to be a videogame driven by character development and cinematic storytelling.
Overcooked is a multiplayer game about falling out with your friends and family cos they let half of the kitchen burn.
Why would I hold them to the same standards when they are clearly different games with different goals.
Bloodborne deals with the fact that the player will "die" while playing the game in an interesting way and ties it right back into the story.
Sekiro even goes further than that.
Plenty of games come up with cool and thoughtful ways to make the sometimes unrealistic aspects of gaming into interesting parts of their own story or gameplay.
For me it comes down to what the game is setting out to do.
Naughty Dog pride themselves on their characters and their storytelling. In my opinion Uncharted falls short.
I don't judge all movies or books or movies by the same standard. Why should games be any different?
You think that The Last of Us and Crash Bandicoot are more or less the same when you get down to how the characters are introduced and how the story develops?