Hi! I'm actually in your position right now.
I absolutely hate being a PSW (I live in Canada but it's the same as a CNA). I worked as a PSW last Summer and hated every minute of it. I have known I've hated it since my clinical in first year at an LTC facility. I am currently in my fourth & final year of my nursing program & there are SO many opportunities for work that is nothing like being a CNA. Of course, many places you go, you're likely going to have to work that 0700-1900 shift. If you choose to work in a clinic of some sort or public health etc, you'll find hours are very different, 9-5 kind of thing.
It does get better. You may never like CNA work and that's okay. You don't have to! There is so much more for you to learn and going to work at a place you love will be exciting again. Stick with it ? Even if you choose to not work in the ER like you thought you would, it happens and you have so many options.