If you just want to fly, then I don't think that you could make a bad choice. I was kind of bummed when I found out that I was not PQ for pilot, but I got over it real quick. In my opinion, you might need to consider what type of mission you want to be a part of. Statisticaly speaking, if you want to be a part of the Strike Fighter community or just want to fly Rhinos, then you probrably have a better chance as an SNFO. Keep in mind that the Growler will be coming online relatively soon. Heck, every SNFO that goes to VT-86 does air intercepts as of last July.
I would venture to guess that close to 50% of SNFOs in my time frame went through Strike/Strike Fighter training at 86. I only know one guy who went to VAW-120 (E2s) that didn't want to go. Panel Nav slots are still competitive also.
Speaking of training at the RAG, us NFO/RWSO types are expected to know just as much about the aircraft and mission as the Pilots. We attend all of the same classes, do all of the same computer training, and crew with the replacement pilots in the sim and for a handful of flights. You will study together alot and party together when you get the chance. At this point, pilots are just doing enough Fam hops to get comfortable in the jet, learn checklists and get a feel for how the jet will perform and what it is capable of. We actually have a bit of an upper hand tactically because we have been exposed to A/G and A/A RADAR, fighter intercepts and self escort strike. Although, they have more ACM/BFM experience than we do. We also had to learn 4 different airframes over a year and a half period. You begin to understand systems relatively quickly. I got my fair share of time on the controls in 3 of the 4 aircraft (No time in the T1. Damn Air Force jet!). It was enough to satisfy me, keeping in mind that I had no prior flight experience.
As previously mentioned, as WSOs, we are heavily involved in flight planning and weaponeering. Career opportunities (in the Navy) are just as available to NFOs as Pilots. NFOs can go to Weapons School, Fighter Weapons School, Test Pilot School, etc. A big advantage we have is, being in a multiple seat aircraft, we have more Officers to spread the ground jobs out. Single seat guys tend to be busier with multiple ground jobs.
As for second class citizens, a CONE is a CONE (Category One Student. i.e. FNG) It doesn't matter how many anchors you have. I asked a Tomcat driver, who was transitioning to single seat Hornets, what he liked most about having a RIO. His reply, "Having One". I think that says alot.
Sorry if I have rambled on. Just want to give you all the info possible. God knows I didn't know a darn thing about what I was getting myself into 2.5 years ago.