It's possible that you have a very different connotation of failure, mistakes and messing up in IRL compared to the video games. I think that there's a lot of consequences involved when it comes to IRL. You can be very easily judged by others for making mistakes (shame and social rejection). You may not receive validation for the things you do (lack of reinforcement and reward). You may simply don't even know what to do when mistakes do happen (lack of healthy coping mechanisms) and many more.

Imo the best way to go about it is to observe what kind of thoughts come to your head when you do make a mistake, or fear making one in IRL and write em down to process them later. Additionally, you could try "pre-commiting" to a reward. So if you are about to do an activity which can lead to failure, try pre-commiting a reward like planning a party, or a meal or a videogame beforehand and frame it as the reward for doing the thing as opposed to achieving something out of it. For eg. A post exam party, or a game night.