Being an NFO is awesome, especially if you are in an NFO-centric community. I chose it first, and I have absolutely zero regrets. We have really difficult and important jobs just like the pilots, and these jobs are necessary to the mission success of the air wing, just like the pilots.
If and when you get to the fleet, you will see that any NFO vs pilot shit is just a joke, and deep down everyone sees what each person brings to the fight. There are many upsides to being an NFO...pm me if you want to know in detail what a Hawkeye NFO does.
With that being said, I do not think it is "worth it" for "someone like you" to become an NFO. You have to want it. If you truly don't want to earn NFO wings deep down, flight school will be very tough for you.
If you want to be a pilot, but you are NPQ for military aviation, don't apply for naval aviation. I wouldn't want someone like you in my ready room who thinks they are superior to the career itself because they were once a civilian pilot.