As Zab mentioned, definitely use the resources at the NROTC Unit, that is what they are there for, and I am sure that they will provide a wealth of information.
But, to tell you the truth, you asked a pretty open ended question, there are quite a few unknowns with that question. But a ROUGH (emphasis on ROUGH) timeline for general discussion purposes:
APR06 Graduation/Commission (Active duty, right? So automatic commission, no waiting on those pesky Naval Academy Grads)
3 month - API, Pensacola (my GUESS, no wait, like me, got there before the Academy and rest of NROTC rush, but waits can be upwards of quite awhile, depending on loading. WORST case, he gets to API, is put in a waiting pool, and gets TAD orders back to the NROTC Unit at Jax until he is ready to class up).
6 months - Primary Flight Training. This can be in either Pensacola (Whiting) or Corpus Christi. If you are still doing the distance game, I am sure that if he spent the time working the angles, and talking to the Student Control Officer, that he could stay there in Pensacola.
Selection for Pipeline:
1 year - Jets (Kingsville, TX or Meridian, MS)
7 months - Prop (Corpus Christi, TX)
7 months - Helo (Pensacola, FL)
??7 months - TACAMO (middle of nowhere, Oklahoma)
Times to train are all guestimates, depending on weather, students in the pipeline, how well HE does, which squadron you go to, medical status (do you get sick?), and numerous other factors. Anys SNAs in the pipeline want to chime in on their time to Wings? lol
Basically what I am getting at, is that at this point in time, you have NO idea of how long you will be apart if you stay in Jacksonville, and whether or not he can get orders BACK there for P3s. At the VERY least, you are looking at a year, before he gets back there for the FRS, and that is if he is smoking through the pipeline, and he selected P3s. Anything else, and he is definitely not coming back there.
One more comment, aviation training can be very difficult at times, but it was also one of the best periods of my Naval career where I was able to spend quite a lot of free time with my wife and family. Don't feel like studying, go hit Pcola beach! I would be hesitant to give up that time, or worse yet, finally be back together, and he is in a Fleet squadron, with a ground job, trying to upgrade, and you never see him.
Good jobs come and go, but your relationship is there for the long haul.
My two cents, best of luck in your decision. If he has ANY questions on P3s, there are quite a few of us here on the forum that are able to answer questions (dispel or confirm rumors).... PLUS a lot of other community guys and gals (helo fags and pointy nosed prima donas to name a few....oh, am I gonna get it for that... BRING IT!!)
Seriously, best of luck.
John