I am a female Academy grad and current officer from a completely non-military family. I stumbled across the academy fairly late (summer before Junior year) but fell in love with everything it had to offer - mainly the opportunity to play tennis at a high level while still getting a great (paid for) education. The Air Force was a complete unknown for me, but I loved everything I read and heard.
I can speak to what it was like at USAFA for me - but that experience varies widely. Same for my Air Force career. It's been about 8.5 years for me and I have only done two different things - school and work for different directorates of the Air Force Research Lab. That is because I am a 61D - one of the smallest career fields in the Air Force.
I recommend you do a couple things -
1. Search this forum for threads like this one -
https://www.serviceacademyforums.com/index.php?threads/year-to-year-life.77510/ or this one
https://www.serviceacademyforums.com/index.php?threads/answers-from-a-doolie.77438/ that give some general info
2. Provide us a little more information. What kind of major would you be interested in? What Air Force job interests you? Your experience at USAFA and after depends on what you choose to do
On a more general note - I LOVED my time at USAFA. Sure it was challenging and I was exhausted all the time, but it was an incredible experience and I never doubted my choice to go. I also love my Air Force job. A 61D is an acquisitions officer, but coded as a physicist. This means I work extremely technical Air Force acquisitions, like future satellites and different kinds of new imaging/remote sensing systems. It's amazing and I couldn't be happier, but I don't have a "normal" Air Force job. I lead mostly civilian scientists - not enlisted Airmen.
There are many other cadets and grads on here with more recent experience than mine, but feel free to PM me, since it sounds like I have a similar background (I also received an LOA and got my nomination and appointment around mid-November my senior year).