As an English/Creative Writing major, I certainly shared in the worry that my choice of education would make me unappealing to the selections board.
But the GPA was good, so was the ASTB. And here's the thing I think most people forget. If you're into aviation, you likely have been for a while. If you're motivated enough to consider becoming a Naval Aviator/Flight Officer, odds are you've been learning about airplanes for a good long while--at least peripherally.
Don't know about anyone else, but as a child I used to talk about aircraft specs the way other kids talked about sports. Nerd? Yes, but that was the personally motivated side of my education. Doesn't everyone have interests that don't find expression in the institutionalized educations they receive?
Being an English major didn't make me a writer or a literature professor. It just increased my knowledge of those areas (and gave me a pretty well-rounded education, I believe). We're multidimensional, and our interests are too. If you want to fly, you have a reason, and that reason has led you to do some of the basic homework already. I would say just build on that. Education, after all, is not something you receive; it's something you pursue.
So I would side with those who say to major in what you enjoy. I see too many people--and this is outside of OCS/ROTC circles--focus their college careers on what job they want, rather than what they want to learn. Result: dissatisfaction.
/Soapbox