To the OP: Usually people who ask these kinds of questions are asking it in the wrong way. You seem to be in a field where you’re unhappy, or unfulfilled, or you wouldn’t be considering a career change in your 30s. Implicit in your question is another one: What are my options if I also don’t like being an NFO. Before committing 10 years of your life to something you aren’t sure about, it’s time to do some introspection and figure out what you’re passionate about.
Many of the people who have made a career as military aviators are people who have been dreaming about flying airplanes since they were young. There’s no doubt that this business can be fun, rewarding, exciting, and all the other positive things you may have heard. It’s also a lot of work, there will be many, many personal sacrifices and it will take a toll on your family and other relationships. So, before you decide that this path is right for you, I would urge you to do some soul searching to make sure you’re doing this for the right reasons.
You’re asking about P-8 NFOs. You don’t get to choose what platform you fly. You should be asking about all the platforms NFOs fly, because you will, more than likely, end up in one of those.
This site is a tremendous resource. Do your homework and ask smart questions. Nobody here can tell you whether a career as an NFO is right for you.