I'm starting RN school in August

, and I also took a CNA course just to see if I could stomach

the 'dirty work' as the OP put it.
All of my instructors, of which almost all are MSN, NP or above

(for my CNA and other RN prep courses) had told the students that they wiped behinds and cleaned up 'bodily fluids' just like any CNA would do - it's a part of nursing.
While CNA courses may not be 'required'

by the schools, I think it is a great idea to take the class to have additional practice in the skills as well as seeing if this is the right field for you before you dedicate 2 to 4 + years of your life (not to mention money!) to a profession that you will end up hating - because you don't like the 'dirty work'.
I've also ran across pre-RN students that seem to feel that CNA work was 'beneath them' which I think is OUTRAGEOUS!!!

I've actually had one tell me "why go backwards, it's not like WE are going to DO THAT kind of stuff!" I just told her she had no clue and walked away...
So, back to the OP, the choice is always your own - you may want to figure out which (the elderly or the 'other') concerns you most and decide if you can rise above it or not. You may also want to visit a local hospital and talk to the nurses (on all levels) and find out exactly what their jobs entail.
Good luck!

Just my 2 cents -
Grumpygs
The following member says Thank You: