Is Midwifery a good career choice

I want to study midwifery but my family is discouraging me because they know I don’t handle other people’s bodily excretions well. I think when I study and go on placement I’ll learn to overcome this problem, especially since most healthcare courses have stuff that make me queasy, to an extent.
They’re also telling me it’s too demanding and I’ll get worn out which I’m not gonna deny.. but at the same time isn’t this something you learn to manage over time? The work hours per week aren’t that different to radiography, (which is what they want me to do) so it’s not like I’ll be at home less. I wouldn’t mind doing radiography but imo it’ll be more mentally rewarding for me to help women in labour and see babies enter this world than to see broken bones and upsetting cancer cases. Obviously midwifery won’t always be sunshine and rainbows but I just want some advice as I’m a bit conflicted atm