Unlike other debt, student loans will haunt you forever. They are not erased with bankrupcy, and typically cannot be renegotiated. I've heard of cases where people have paid twice or three times their original debt because their payments first go toward interest, then toward principal. Depending on what kind of student loans you have, you may be responsible to make payments even while you're in grad school.
Grad school may actually be worse than undergrad for the time needed to study. Think about your nursing school class, now take the top 25% or so: these are the type of people in your grad school class (or top 5% if you're in a highly competitive program... maybe top 40% if you're in a less competitive program--but you get the picture). You may find yourself at a disadvantage with only 9 months work experience, not just for the academics, but when you're applying for jobs many employers want to see years of experience along with the NP degree.
It's likely you have $40,000 or more in undergrad debt. A respected yet inexpensive DNP program might cost $75,000 to well over $100K. Add that to your undergrad debt and it could be financially crippling. How will you help pay your kids' college tuition, buy a house, a car, or have any disposible income if you're straddled with so much debt?
Dreams are one thing, but whether you're dreaming of a vacation in Tahiti, a new Porsche, or a different career, the reality of paying for those dreams sometimes makes them unrealistic--at least for the time, being.
You don't have to give up the dream, but consider postponing it until you have more nursing experience and some money in the bank.