Welcome to the poop show that is bedside nursing. In all seriousness, even though I loved psych and substance abuse, I had to get out of it due to the constant stress from the rising acuity. I got to the point where I was gun shy, I was afraid I would freeze up while trying to deescalate someone and that either I or a co-worker would get hurt. Eventually that anxiety just wasn't worth staying where I was out.
The potential for violence is in every specialty in nursing. Certain specialties attract it more than others, ER, ICU, Psych, memory care, all see their fair share of violence. It is NOT acceptable but it is a sad reality of nursing. You will have to decide what you can tolerate an what you can't when it comes to your job. Sometimes time and experience and being exposed to those type of situations can help you manage them when they occur.
However, I would encourage you to stay put to get experience because no matter what job you have as a new grad, it's going to be hell for a while just because the first year always is, so as you gain experience a few months down the road your current environment may not seem so intimidating.
Good luck!