No matter what service you are in, you will repeatedly hear "the needs of the service come first". The military doesn't exist for your pleasure, you exist to make the military function. It can happen in any service, I personally know an Army Major who is a pilot who did a one year infantry tour in Iraq. In the Air Force, you could do an ALO tour if you are a fighter pilot (ALO tour is being assigned to an Army unit and directing airstrikes with TACPs). Also, you could fly a UAV. In the early 90's, lots of officers waiting to go to pilot training ended up doing 3 years in other jobs such as Security Forces, missilier, and more because the training pipeline was so backed up. If you go into the military without understanding that you are an officer first (and pilot second or whatever your Jo title ends up being) you will be disappointed. Having said that, I was a little disappointed when I first joined the Air Force, but in the end I was able to look back and enjoy my time and was proud of what I accomplished.