+1. Especially since you can reload in a video game.
In a tabletop session, yes it is dumb to attack an Adult Red Dragon at low levels. But - and I recognize this is a very polarizing topic - some people would argue that DMs should adjust situations to the party's decisions and not kill characters. Please don't focus on whether you agree with this statement. All I'm asking is that you acknowledge that some players will be very attached to their characters and not want them to die. In some heroic-fantasy games, player death is not expected and the DM will come up with other punishments/results of characters' actions (see @Leucrotta's post above).
I totally agree with you here - tabletop PnP is different from videogames in that regard. Nonetheless you still want to feel like the game reacts logically to your decisions.