Yeah they try and train the nerves out of you as best they can so the responses are automatic, but the realization that there are hundreds of people's lives in your hands while you're dealing with (a V1 cut in IMC)[https://m.youtube.com/watch?v=ziFgVrzBvDg] can be nerve-wracking. Or even flying a GA plane and losing your engine over some mountains without a place to land. There are always tons of scenarios you've trained for, but even more scenarios that are too specific and "unlikely" to even begin to prepare for. A good example was Captain Sully landing that A320 in the Hudson. There was no training for anything like a dual engine flameout at the time because it was so unheard of. You can bet that he and his FO were sucking up seat cushions due to the magnitude of the situation but they used their experience and professionalism to deal with the emergency and work through the stress safely.

Responses should be automatic but we're all still human, and if the training is done well then the stress should hit after everyone's on the ground safely. Being a pilot consists of long periods of boredom interspersed with short periods of sheer terror sometimes. And the point I'm trying to make is that most pilots really do work hard to make safe choices. Most all are just in love with their job and wouldn't take risks of any sort in fear of losing it. It now takes 1,000 hours of flight time to even be considered for a job at a regional airline, which I'm not about to mess up. Ever since the movie Flight came out (which I do love btw), a lot of people think that pilots are prone to heavy drinking, which couldn't be further from the truth.