And say if I don't get a pilot slot, I would like to do something in the Air Force's Space Program, what kind of careers are in that field.
Ok, not a USAFA grad here (was an ROTC guy out of VMI). I was a 13S, which is the AFSC for Space and Missile Operations. This is, I think, what you mean by "the Air Force's Space Program." This career field is undergoing some changes; but, I'll give a brief overview of what it was/is/is becoming from my experiences.
In my day (1999-2003), you would report to Vandenberg AFB in California as your first duty station, which is where training takes place (it is still the initial training assigment for all 13S). In my time, you did not know which specialty you would have until completion of an initial course (about 4 weeks long) that gave an overview of the various Space/Missile core fields. Nowadays, form my understanding, new 2LTs know if they will go the "Space Track" or "Missile Track" before reporting to Vandenberg. If you are Space, the mission areas are Spacelift (launching of rockets), Space Warning-including Space Surveillance: ground-based and space-based (using ground sensors or space-based platforms to detect objects in space), and Space Command and Control (operating or "flying" communications, weather, whatever satellites from control centers). If you are missiles, you perform ICBM combat crew duty (alerts in underground launch control centers operating Minuteman III missiles).
It used to be that Space/Missile officers would "cross-flow," meaning that you would perform one missile tour and follow-on in space. Now, with the new stand-up of Global Strike Command, my understanding (from 13S folks I served with who are still active duty) is that guys with a space assignment initially (i.e. new LTs) will stay space their whole careers, moving from one mission area to others. Missile guys will do an ICBM tour, then some will be able to transition to space, while others will be retained to be senior level experts in the ICBM field.
The realities (then and now): 75-80 percent of Space/Missile 2LTs are assigned to a missile base as their first assignment (higher manning demands). This was my case, and I separated from the USAF after my commitment was up. Missile duty is not the most exciting thing to do in the USAF, and all the bases are in cold, norther tier places. I spent my time at Minot AFB, in North Dakota. That said, earning the "pocket rocket" (missile badge) gives you cred with your 13S peers, and it IS an awesome responsibility to sit alert. But, if missile duty does not appeal to you, it is best not to put in for the Space/Missile career field as a first choice. You may get it anyway (needs of the AF). Also, don't be lured into the AFSC because it sounds cool. Some of it is, other parts are repetition and tedium. For instance, spacelift sounds really cool, and seeing the rockets on their pads in Vandenberg might make you think that. The reality is that contractors handle the vast majority of duties, and actual launches are not that numerous. Spacelift is a better assignment for an O-3 or O-4, as you will have the seniority to actually get to work one of the few lauches that occur.
So there you have it, hope it helps.
