If something clearly isn't for you, it's a smart move to quit early on. Good move that you did it asap.

My husband is RN and when no aid is available (which is often) he cleans and does menial work because it needs to be done to help a patient. If you can't do that, you shouldn't go into nursing. But it doesnt make you a failure. I wouldn't go into medical field for nothing. Ton of people would not go into my field either. I teach high school and many people can't even imagine dealing with teens all day. You aren't required to do something just because others do it.

I recommend go to career type of counselor and see what they suggest, they might have some ideas for you. Good luck