I am from the NYC area, and it's true that the number of schools offering NNP degrees have decreased recently, including Columbia University, my own grad school. The NNP market is a bit oversaturated here on the island of Manhattan, and even in NJ and the rest of NY. You can find the occasional NNP position on Long Island or upstate.
My personal opinion is that it's just not profitable for schools to pay for an NNP program, which involves hiring a director, doctorally/masters prepared professors, clinical sites, etc when there are only 3-5 applicants per year, which was the case at Columbia. That program closed because of low demand, and transition periods within the school of nursing. Stonybrook has a large and popular NNP program, which a lot of RNs gravitate to, because most NNPs are working as FT NICU RNs and prefer the distance option, AND it's a third of the cost of Columbia's program.
To answer your question about PNPs...my hospital no longer hires PAs or PNPs for the NICU. We have a few left from before the new rule, but now our directors only want board-certified NNPs, which helps with Magnet and US News & World Report status.
A lot of our NICU RNs got their PNP only to get screwed out of a job in our unit. It's a shame because they would bring such a wealth of needed knowledge.