First, as with any other profession, there are good nurses and there are nurses who, well, are somewhat less than good. Remember that, and that you are bound to run into some of both.
Next, I'm sure you have already figured this out. There are some things that you will be taught in nursing school that you will leave behind the day you graduate. No big deal, just some things that aren't really applicable to your practice. The trick is figuring out what can be safely left behind, and what cannot. What you learn about patient safety absolutely cannot be left behind. I'm glad (both as a nurse and as a father of small children) you are not leaving patient safety issues behind, they are important. Some nurses have trouble filtering out what they can forget and what they can't, so they tend to want to forget things willy nilly, and hope for the best. Definitely not a safe way to practice.
Also, you will run into some nurses who are hard workers, and some who are lazy in your professional life. What the nurse told you about the social services consult is essentially true in most places, it must be ordered by the physician. But, what a nurse who does not fit into the lazy category would do (and I don't want to hear about being overworked, yadda yadda, patients come first) is to plant the bug in the physician's ear. I have gone as far as telling a physician "this family needs a social services consult. OK if I write for that under your name?" That's part of your job, you spend a great deal of time with the family. You will learn things about the patient and family the physician may not have time to learn. S/he counts on the nurse (if the physician is good) to bring those kinds of things to his/her attention.
Finally, as Sjoe said, relax. Do the best you can, and don't let nurses who do not fit into the hard working, or less than good categories, affect your learning as a student. Enjoy yourself.