Seriously, if you're complaining about not being aviation/nfo and not being swo/nuke/sub/etc, you deserve to be punched in the face.
We're you guaranteed a flight slot when interviewed by your recruiter while applying for a scholarship? No. So then why are you acting as if you were guaranteed one and got screwed over?
I bet you a majority of NROTC applicants, when writing their essays mention that the reason why they want to be a part of the Navy/Marine Corps is because they want to serve their country, not because they wanted to be pilots, etc etc. I know I certainly wrote that and what some of my colleagues did too. So, you're given the opportunity to serve your country, only in a different capacity then desired, what's the problem?
I for one wanted aviation first, NFO second, but ended up service selected SWO. Was I bummed out? Yeah, a bit at first, but immediately afterward I moved on. I realized that regardless of what I selected, I will still be a part of what I wanted to be for quite sometime, a United States Naval Officer. I still have a job waiting for me when I graduate and will still be given the opporunity to represent my community as I serve my country. Different job, same satisfaction.
After thinking for quite sometime, maybe this job is meant for me, who knows?. You know how the saying goes, "everything pans out in the end". I surely think it does.