A goal to be a CA at a major is not noobish...that is the only way to make all the entry-level garbage pay off in the long run. Actually your goal should probably be to get HIRED at a major. If you do that, and are young enough, you will be a captain eventually (it's all based on seniority).

Your GPA is marginal for a navy commission in any specialty. But they look at the whole person, so other things like athletics, leadership, initiative, and outside activities may weigh in your favor. If your degree was hard science or engineering that would help too. Your NROTC participation shows long-term interest...ie you didn't just wake up today and get a wild hair about the navy.

Since you are airline oriented, I would look for a flight school guarantee...that way you at least know that you will get a shot at flight school after OCS. If you just join the navy, you will probably end up on a ship...you will have 2-3 years of hard work before you can even apply for flight training, and then there are no guarantees.

Your aviation credentials should help you get a flight guaranteed slot. But you will want to forget your civilian experience once you get to flight school.

I think the number one graduate in flight school usually gets his choice of aircraft...but even then they might not be taking any fixed wing guys from that class, it might only mean your choice of helos. Basically its a crap shoot. I'm all about the navy, but an airline wannabee should probably look first at the air guard or the air force (active or reserve)....not very many helos in the USAF.