If you are born with a penis they do despise you for your weakness. You need to be the absolute solid rock in their life.
Any signs of the that rock is crumbling and she will lose the respect for you,
(
and eventually find a new rock).
For any other animals, creatures, aliens, children and female sisters exception applies and she you will love that are showing her feelings and weakness which she can connect too..
For what do you need to be a 'solid rock'? You don't need to be anything in the first place...
Will a woman be repelled and the relationship with a woman desexualized, will she be pressed into the mother role rather than the GF role?
I'd say yes. I think we agree on this one.
But what do you mean by 'being a rock'?
I argue it's not putting yourself into the role of a victim. That no matter how broken you are, that you try to get up and forward. (Edit: Also being stoic, independent, financially secure, ... I think we agree on this too)
What is a LTR GF good for, if she is unwilling to accept your weaknesses, is unwilling to help you overcome them, or is angry because you can't be 'perfect'? I'd say this would be a person that takes up the most important, closest space of my ship that sails through life, but is taking a sunbath on deck at sunshine, doesn't move when the ship is in a storm and is the first to take the life boat when the ship is close to sinking.
To get some data on my assumption, maybe try to tell someone random (a woman) about a problem where you expose a weakness of yourself, and ask for their help. But in an upright, condident manner!
And then do the same, but present yourself as a victim.
Also I think it's pretty narrow to think men have to be like the main character from American Psycho (perfect from the outside) in order to be lovable.
And women are able to connect with men, and as we men connect with other men by becoming vulnerable (Edit: exposition, more generally) (through action or private talk), women and men can do so as well. Life is not about sex all the time.
(Edit: Also note I don't advocate being effeminate. But in my experience, you can do everything with a 'male touch'. Even being empathetic or vulnerable.)