No!
Putting a shooter through hell is one thing. Train to Failure. But failure is the Teacher. It will happen all by itself, with no simulation. In the Realz Wurld a catostrophic miss is often a career ender, and many times a lifestyle ender. Why in the world would we contribute to that mindset? We want our shooters to think that they can be successful. Otherwise we get the Uvalde "mother may I" (if proven) situation. People refusing to decide, and trying to force others to.
This is an area where catostophic misses need to be the bogeyman. Punish the misses. Depending on the class, ALL the misses. Incorporate (from the EMS world) autofails in drills. Then retest, to a limit. Let the shooter's imaginations, with coaching, realize the problem. And in units with, oh, say, a hostage rescue mandate: explain, train, then enforce.
Professional and peer pressure can go a long, long way...But learning, not punishing should be the goal.
pat