I'd Is it common for straight women to not like traditionally masculine "bad boy" men?

I'm very insecure about women. I'm (25) and have never been in a relationship. I've only had sex twice.

I want to date but Im worried women prefer bad boy. How well-founded are my fears?
I worry that any woman I date won't be actually attracted to me. I'm not an especially masculine guy and have no desire to be one. I've always been introverted and bookish. I don't like being very aggressive in bed.

I was always told "Girls may like bad boys and jocks now but when they're older and want to settle then they'll date somebody like you!" The thing is I don't want to date somebody that just views me as the stable alternative to the sexy guy she really wants. That's like how I choose salad because its healthier even though I prefer burgers. It's not that my tastes have changed.

This is very common in media created by and for women. Gilmore Girls, Fifty Shades (which was incredibly popular), and Outlander. Outlander involves a woman cheating on her professor husband with an aggressive brute.

You can say these are just fantasies, but fantasies don't exist in a vacuum or come out of nowhere. There's even this line from Psychology Today:

"the delicate, tentative guy who politely thinks about you and asks if this is okay or that is okay is a guy who may meet the expectations of your gender politics (treats me as an equal; is respectful of me; communicates with me) and your parents’ preferences, but he may also put you into a sexual coma—not despite these qualities, but because of them."

Even based on women I know personally much of this holds up. For instance, I knew a 27 year-old woman (very well-educated) who almost risked her job to get with a buff, tattooed frat guy.

I don't want to be in a relationship that involves such an asymmetry of attraction. That puts me in a vulnerable position. The other hand is that I can't suddenly become an aggressive bad boy. What if I'm on a date with a woman and some guy insults me? What if some drunk tries to fight me? Is she going to be turned off seeing me being beat up?