What you do in clinical isn't what it's going to be like in the real world. In clinical, you have to do total patient care - baths, toileting, grooming, meds, dressing changes, everything. In the real world, it all depends on where you work. In the ICU, you may have patients who are 1:1 and you have to do everything for them. You may work on a med-surg floor that doesn't have CNAs or Techs - so the nurse has to do total patient cares on their patients (won't see this too often, but it does happen). However, if you work on a unit that does have CNAs or Techs, you won't have to do as much menial tasks. Many nurses still do some of the menial tasks because it's about team work and it's good to help out the techs - especially if they're short staffed or really busy. But it's not like that's all you do. I'm in my second to last semester of the ADN program and I currently work as an LPN to pay the bills.
Even at a LTC facility (where I work as an LPN, I was also a CNA for 11 years), you won't have to do many of the menial tasks. Usually, I am way too busy charting or passing meds or dealing with faxes or doing assessments to take residents to the bathroom. I will do it if I am not busy or if it's a safety issue - such as a resident on an alarm keeps standing because she needs to go to the BR and everyone is busy. But usually I don't have time. In fact, most of the time I am busier than the CNAs. This is the same for just about any facility/unit with techs or CNAs. In one hospital we go to for med-surg, the nurses have to chart every 4 hours, maybe more for certain situations. They also have to do assessments every 4 hours and they're always running around doing dressing changes, getting pain meds, emptying wound vacs, and dealing with the doctors. It's not too often that I've seen a nurse shower a patient or wipe a behind. Sometimes, you may have a special case where the patient requires special care where only a nurse can provide cares, but not too often.
Believe me, you're not the only one who is frustrated with the way clinical works. My personal opinion is being a CNA and having working experience of 6 months or more should be required to get into a nursing program. I don't mind showering and toileting and stuff, but I've done it for 11 years (in a hospital and LTC) and to me it's taking time away from nursing tasks - which I don't have near as much experience with.
Anyway, at my school, towards the end of the year our instructors don't require that we do total cares, but if our patient needs something and we're not busy we should help them go to the bathroom or whatever. In many nursing programs, students aren't required to be a CNA. They may have to take the CNA class, but don't have to get their certification or work as one. That's why many programs require total patient care because many students don't have that experience. So don't base whether you want to be a nurse or not on your clinical experience. Now, if you think blood is disgusting or urine makes you vomit, I would suggest you find a different career - but it doesn't seem like that's the case.
Also - there are so many fields in nursing, it's crazy! When you have your RN and your BSN, you can do so much. You could be a vaccination nurse. You could work in a dialysis center. You could manage careplans. You could be a wound nurse. The possibilities are endless. Don't give up and don't get discouraged.