I went to both academies. From my understanding, you have to go rated at USAFA to become pilot, some get drafted into RPA. At USNA, you may get put in NFO due to needs of the Navy.
Things to consider: college/service culture (both have very different cultures), types of aircraft, and 2nd/3rd...