Aargh!!! JUst posted a huge message which has f**king disappeared.....
Anyway; upshot was:
I am RAF wife who also served as an officer for 7 years and left 2 years ago. I have one dd (7 months) and I work 4 days a week as a Project Manager. Most RAF wives with pre-school age children don't work, for a variety of reasons. Some through choice, some because what they earn doesn't cover the childcare, particularly if they have moved around a lot and their careers took a back seat. Of my post-natal group there were 6 RAF wives and I was the only one who returned to work.
As an Int O your dh will def spend a fair amount of time away in some pretty 'interesting' places. Whilst he is training at Cranwell you will not get to see him much (max 70% of the weekends for 8 months, and he will not be able to leave early on Fridays!). In addition, he will have work to do over those weekends.
Having said that; he is unlikely to get in as an Int O. Hate to rain on his parade, but Int O slots are like hens teeth and tend to go to either people who have joined up as a junior rank in the Intelligence trade and are very good, or people who come straight in with double firsts from Oxford/Cambridge etc(but that could be your Dh, I guess!)He does need to be realistic about the trade he has chosen. He may go for selection and be offered another branch entirely, so has to think whether he wants to be an officer in the RAF and would look at other branches, or only wants to be an Int O.
As for the commuting...plenty of people do it and make it work, but it is bloody hard. I did it without kids for 5 years and I dont want to do with kids if I am working. DH goes away a bit now and that is hard having to do everything as well as working....if I had to do that 5 days a week for years on end with no support from family etc because of where we live I would not be a happy bunny! I accept that when he is sent away I would have to get on with it, but we will do everything to be together the majority of the time and move when necessary. When it gets to secondary school age I will reassess, but I was moved through a few primary schools because of my families miltary background and I always enjoyed school...however you will obviously know if your dc could adapt or not.
Let me know if you have any other queries.