Women like so-called 'bad boys' because they are sexually aggressive. Women want to be dominated sexually, as this is what makes them really wet. Being overwhelmed, overpowered and dominated is part of the female sexual response and corresponding sexual arousal. Nice guys are not sexually aggressive enough, as part of their nice guy persona is being non-sexual around women so as not to offend them or make them uncomfortable. Therefore women see nice guys as a non-sexual entity. Nice guys do NOT make them wet or make them yearn for cock like a bad boy.
The 'women want someone aggressive, chest-thumping chimp' narrative we've heard a billion times before.
The truth is that people pleasing behaviour is what is not attractive to women, it's nothing to do with failure to conform to some stereotype of what some alpha male could be.
The only validity on the 'more aggressive=more attractive' trope. Some guys when they're attracted to a woman don't let her know or make it clear they're attracted to her. She gets mixed messages, gets to the conclusion that the nice guy isn't attracted to her, loses interest, moves on to someone else. This is a common situation. This 'more aggressive=more attractive' trope is simply a misinterpretation. All that's required when you fancy a woman is to simply tell her that you like her (if you're already behaving in a way that suggests that). Some guys reach the erroneous conclusion that their love intest didn't like them back because they were't macho and aggressive enough. This is the sort of clack-and-white thinking that we get when we're feeling emotional! It's not the absolute reality!
This idea that more aggressive=more attractive is a very simplisitc conclusion based most likely on people's theories as to why their own unrequited love interests haven't worked out and b) confirmation bias; giving more attention to evidence that supports what fits one's belief and ignoring evidence to the contrary. That's why there's so much shitty PUA advice, and that's why the manosphere community is full of over-smplified nonsense.
The truth is, attraction is ultimately subjective and a lot more complex than simple 'more aggressive=more attractive'.