If your goal is a tenured position in academia, you will be better served by the PhD. A number of schools
don't recognize the DNP for tenure purposes (just as many psychology programs don't recognize the PsyD for tenure purposes, just the PhD in psychology). The last state university in which I taught, a reputable nursing program but not a "big name," high-profile school had already decided that it was not going to recognize DNPs for faculty/tenure purposes; DNP-prepared faculty would have the same status as the MSN-prepared faculty (not eligible for tenure, not able to vote in faculty meetings; i.e., "second class citizens").
There are plenty of schools that don't differentiate, of course, but you never know when, some time in the future, you might find that an opportunity you really want isn't available to you because of the degree. On the other hand, the financial considerations are significant. Best wishes for your journey!