+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).
In BG3, if the Red Dragon attacks me with its full might and TPK's my party, then that's a great! I get to experience the consequences of my actions - getting my ass handed to me - but then can reload and still have the characters I like playing with. Additionally, this opens up the possibility for challenges: I might try again and again and again to beat this dragon, feeling real triumph if I eventually figure out a way and win after countless grueling battles. This possibility is lost if the dragon just flies away when you attack it, or it every enemy we face is scaled to be at a level we can easily win against.
Phrased Differently: Video games can be more punishing than tabletop because it is much less effort to reload than to create new characters.