I still think you would be very competitive for admission to nursing school with a degree from Stony Brook. If you were going onto a PhD program in public health, I think Emory or Columbia would increase your chances of getting into a top program.
I am facing this same dilemma. I got into the PhD program at Buffalo, which would be dirt cheap (relatively speaking) and a faster route to my PhD, as well as Albany's master's program (a cheap route to a masters degree). I also got into both Emory and Columbia, as well as the University of Washington (cheaper than private schools, but still out of state tuition) Since I want to go onto a PhD program in the public health field, I am leaning toward the stronger programs, simply because I would come out more competitive for admission to top programs.
That being said, the idea of taking out a huge loan (on top of my existing undergraduate loans) is simply terrifying. I have talked to a few professors in their mid-30's with upwards of 80K in loans. That would really affect quality of life (ability to get loans for house, car, etc).
The money issue is so important!! If you're going onto nursing school, I think you will be fine with a degree from a less prestigious school and you'll be starting off with fewer loans. If I were in your shoes, I would probably pick Stony Brook.