as a former NFO I can tell you what my experience was like,
I flew A-6 Intruders as a B/N which is Bombardier/Navigator. My job was to handle all the navigation, weapons delivery and communications of our mission, including all weather, low level, attack missions with a huge range of weapons, including nuclear. Back then, the A-6 and the F-14 were the primary punch of the carrier air wing. Today, both missions are covered by the Hornet. The closest analog to my old job in today's fleet is super hornet WSO.
It wasn't my first choice coming out of VT-86 (I wanted F-14s), but after i got into it, I realized it was the best possible job for an NFO (most aviators realize that their platform is the best platform and wouldn't want it any other way)
I became an NFO because I didn't get my first choice, which was pilot. My vision was really good (20/15) , but needs of the navy dictated that when I got selected for AOCS they needed NFO's. NFO's have to meet vision requirements, SNAs (student naval aviators) are Class I, NFOs are Class II. details are at
https://www.med.navy.mil/sites/nmotc/nami/arwg/Documents/WaiverGuide/01_Physical_Standards.pdf
Pilots must have 20/40 uncorrected, 20/20 corrected. NFO's must have 20/20 corrected, no limit on uncorrected.
These days, the pipeline for SNAs and SNFOs starts with IFS (Introductory Flight Screening). At IFS, both SNAs and SNFOs get basic flight instruction, including ground school and some time in civilian type aircraft, something like 20 hours or so of flying, including solo time. If you go USNA, you can do Powered Flight as a summer training option, which is similar and allows you to skip IFS and go straight to API (Aviation Preflight Indoctrination) at Pensacola.
At Pensacola, all SNAs and SNFOs go to API together. It consists of around 8 weeks of classroom instruction and a lot of aviation survival type training. Classroom training consists of the "big 3" - Navigation, Aero, and Engines
After API, SNAs go to flight school at Whiting or Corpus. SNFO's go down the street to VT-10. Basic is the same for everyone, after that you select for P8s (no P-3 anymore), or carrier based. In Intermediate, you select either E-2, or Strike (super hornet) , or ECMO (growler) there might be other options too. In advanced, you learn your specific community then get your wings. After that, you go to the RAG (training squadron for your specific platform) which lasts about a year, then you go to a fleet squadron.
I loved being an NFO in the A-6. In our community, the B/N in the right seat could be Mission Commander and had a ton of responsibility leading air wing strikes. I think Growler ECMOs and Super Hornet WSO's can be in a similar role.
If you want to fly and can't be a pilot, you should seriously consider NFO. NFOs are not as plentiful as they were back in my day, but there are going to be NFO jobs for a long time.
best of luck