A woman once said to me, "You're not an alpha, but you're not a beta either." I've been married a long time and my wife loves me - but she doesn't want to have sex with me, and she had at least one (very sexual) affair. There's something about me, a non-"player", that turns my wife off, sexually, and something about that guy outside of our marriage that very much turned her on. The only thing she ever said that came close to an explanation (before her affair) is her saying, "I find sex in long-term relationships difficult." I've pondered why this may be: being taught that sex is dirty therefore something to be hidden? The influence of her father, a very decent but slightly socially-inadequate man? Or just the general difficult we all seem to have when it comes to be open about our sexuality and desires? Or - probably more likely - none of these things.
There's another angle. What's the single most attractive quality a man can have? Confidence. So-called "players" usually have this. However, taking it out of the context of sexual relationships, I have to recognise that I find confidence attractive in my male friendships, so it's an important factor beyond just sexual relationships. In the early years of our marriage, I was stricken with, I suppose, a lack of confidence: I was trying to be a half-decent father, having two sons from a previous relationship, struggling with a difficult job whilst having a couple of fairly common chronic illnesses, and being utterly bewildered and dumbfounded by my wife's apparent and sudden lack of attraction for me. So, my confidence - and probably any degree of attractiveness I had - plummeted.
Talking shite to a woman in a bar, or online, is a piece of piss. Holding down a life and keeping things together, whilst remaining attractive to your long-term partner, is far more difficult.
There are some other great ideas in this thread. At almost 60, I am, in some ways, at peace with myself, but the idea of what attracts women is still a fascinating one, because it's what the continuation of the species is built on.