So there's different forms of cowgirl.

You can do the on where you're on your feet and you bounce. You can also sit on your knees/legs and bounce that way, much less athletic.

Reverse cowgirl is the one that drives me crazy tho. It's basically the same thing as doggy style, where you aren't facing each other, and depending on if you bounce on your feet or knees/legs, you can get the same range of motion as doggy style. But reverse cowgirl also gives the woman control, which some women and men (and non-binary pals) like. Obviously you sound super submissive so that's not a position you'd enjoy.

But I think as with most forms of cowgirl, women aren't necessarily doing that position because they want to use the full length of someone's dick. There's more of an opportunity to grind while there's a dick inside you. Can be a different sensation for some than just pumping, which for some can mean sex becomes actually enjoyable rather than being slightly/modestly uncomfortable.