First, doctorate for APNs remains so far a "recommendation" and "endorsement", not requirement or "mandate".
American Association of Colleges of Nursing | Frequently Asked Questions
The very much similar "recommendation" regarding all entry-level nursing positions requirings Bachelor's degree is being so "endorsed' for the last 20 years while LPN, LVN and ADN programs are still blooming and doing just fine.
Second, "rank" of undergraduate program hardly ever matters in terms of future education. Unless one plans a very concrete career strictly in particular academic field, there appears to be no benefits of attending 'high-ranked" school for the first degree. As long as the school is certified, it is fine.
Third, nowadays the trend among really good NP programs appears to be requiring solid clinical experience from all applicants. That was a requirement for CRNA and Certified Midwife programs long ago, but now administration in schools other than diploma mills got it, too. I'd researched most of campus-based Adult Acute Care programs on Midwest and East Coast for my own future career, and the better and higher-ranked of them currently "strongly prefer" applicants having a year or two of bedside experience, preferably in acute care. From what I see, grads of "direct-entry" MSN programs have hard time finding clinical jobs without previous experience.
I really do think that you're going to miss anything. Try to shop around - community colleges are still relatively cheap and may like your previous degree and CNA. Some of private schools are sort of "specialize" on career-changers and may be very welcoming and offer scholarships for students like you. Good luck!