I’m not going to focus specifically on his dream to be a pilot. My take is that WS’s are often very unhappy with themselves and their perception of their reality. This is part of what sends them looking elsewhere for external validation and "happiness." They are deeply unhappy with themselves and rather than work on their big issues, they look for something else to make them happy. If I only had a pilot’s license, if I only had someone who "made" me happy, etc.
Gently, you glossed over the fact that he’s had multiple "minor" infidelities as well as the current one. I urge you to not think about his childhood dream and his desire to focus on it now as different from his tendency to chase what he doesn’t currently have. As others have pointed out, this is not the time for him to be chasing his dreams, whatever they may be. This is a time when his sole focus should be on the destruction and pain and harm to others that he’s caused.
His BIG educational and developmental project right now should be figuring out his shit and becoming a decent spouse and partner and parent. Period. This is not a small job. It is huge. Figuring out how to be an honest and caring partner is a huge challenge for most waywards. He may be really remorseful right now, but waywards always—always—need to really dig deep into the lifelong tendencies and thought patterns and behaviors that have led them to pursue affairs. His refocus on piloting right now is, regardless of how long he’s been interested in it, a way to distract him and chase the next happy pill. If I only had my pilot’s license, I’d finally be happier. . .
What I want to say is that I sense a small amount of pick me in your response to his desire. We often as betrayeds think, wow, how unhappy he must have been to be doing this. How can I make him happier with his reality and our marriage? We turn our attention to fixing EVERY problem and getting things back on track. If he’s so unhappy, how can I help him get what he wants so he won’t look for it elsewhere?
I’m not saying that’s what you’re doing, but really, sweet sister, the last thing you should be worried right now is how HE can be happy and reach his dreams. It’s a distraction for you to the healing that you need to be doing. It’s also a distraction for him of doing the real work and education that he needs to do. It’s also a distraction from what should be the focus: what he’s done to you, how and what he needs to do to support your healing, and how he became a person who can cheat and lie to his spouse.
So I’ll be a wet blanket and say, no dream-chasing for him right now. Both of you need to be firmly focused on reality and the now. Becoming a pilot won’t make him happy until he has figured out what’s broken inside him and address his own internal, intrinsic validation and happiness with who he is. Until then, whatever he’s off chasing next will just be more of the same.
My two cents for what it’s worth. I’m so sorry that you’re here and going through this. It is the worst.