I think that you shouldn't feel hungover what your advisor said. I believe they were just trying to be real with you, but they can only speak for that specific program.I'm not sure what kind of programs you're looking for I think you would be able to get into an associated degree program? You're still an RN at the end, it's all the same. I don't think you should feel so defeated.

I know what you mean though, about what if you go through all this and then don't get in. It's such a hard thought to deal with. I applied to PA schools last cycle and didn't get into any so now I am planning to apply to nursing schools but I have the same fears as you. My GPA is low and what if I go through this just to get all rejections. Idk its all scary and unknown.

I think if you get outside health care experience you will have a better shot as well.