And I thought the Bond movies were supposed to be about a strong alpha male. Well, at least they used to be...
While women may desire strong alpha men, they do not like a certain aspect of alpha male-hood.
In each of the Bond films, Bond easily gets the beautiful girl to fall in love with him. But by the next film, he has moved on. The Alpha male has lots of women desiring him. Thus, he has little need of any particular woman, who he can easily replace if she becomes tiresome.