Certainly, I would say that piloting is exciting and demanding. However, most forms of flying can be downright dangerous in certain circumstances and different people will have different perceptions and thresholds of acceptable risk, some of which will be at a subconscious level. AFAIU, the subconscious concerns can cause problems when sufficiently triggered. I experienced problems with this after years of dangerous FJ flying. Even if the individual is very keen on flying, the sudden manifestation of symptoms, that the sufferer has little control over, can be devastating.
Interestingly, much later in my career I found the stress of poor work/life balance and overtask/overload at work (flying, teaching, examining, paperwork, rule bending/breaking, wars etc...) difficult to manage at a conscious level. This did not precipitate unwanted behaviour but, left me feeling overstretched and overstressed.
OAP