What blastoff and AK Hawg said is true, the guard gig can provide the best of both worlds. Serving your country, occasional deployments, staying with the same unit (as long as it doesn't get BRAC'd in the future) and the ability to fly civilian at the same time.

Normally I would say that you can't get the simultaneous adventure and a$$pain that active duty can provide in the guard, but a lot of guard units are deployable and do so, especially now.

For pure adventure and a$$pain, carrier Navy is the only way to go. I wouldn't trade my experience of boat flying for anything, but I am getting out and going part time at this point in my life.

One thing to keep in mind with active duty Navy also is that even if you do get a pilot spot (which is easy enough if you work hard and pass the medical) you won't know if you are going to fly fixed wing or helos until after primary flight school. With your experience you should do well enough to stiff arm the helos if you don't want them. The Air Force has a much smaller percentage of helos than the Navy does.