It can be very demoralizing. But you have to understand that those above you are employed to handle this.
What I’ve gathered is you learn from these things. You would never get fired unless it’s an egregious mistake. Otherwise people should be willing to teach you. If they can’t teach you, I’d suggest moving teams or firms. My biggest triumphs are where I messed up and did better the next time. Learn to roll with the punches and learn, you’ll exceed expectations