I hated CNA training, but had to have it for acceptance into nursing school. Really, really hated it.
It would be important to explore why you dislike CNA work. For me (and I may get flamed for this) I really dislike assisting with ADLs. I don't want to feed, toilet, ambulate or provide oral care for pts. Obviously I do it with a smile when I need to......but it is maybe once a month or less that I have to attend to that sort of thing.
What kind of nursing works for me? Procedures! Love it! Several different pts throughout the day, lots of education and calming patients who are nervous, providing moderate sedation. Good stuff!
Although CNA work is important because you go have to know how to do those things and to relate to pts on that level, you don't have to enjoy aid work to find a nursing job you love!