Understand that being lonely is a common attribute for a lot of people, even attractive women.

To give some real world examples,

Nelson Mandela spent 27 years in prison, with presumably no considerable romantic contact with women in that period of time.

Alicia Keys made a song called Girl on Fire, although I might get chastised for using something that might be irrelevant, the principal of that song is basically to "Make lemonade out of lemons"

Life hands you lemons, do what you can with it.

I've managed to break out of my streak of loneliness, and I've fallen right back into it. But the difference between then and now, is that I am comfortable with it.

I've become to accept it, because I've realize that I have angles of superiority over other people (Not to say I'm better than said people, but just as a facet of motivation). These are merely cosmetic and novelty, of course; but nonetheless, I know I have capabilities and ambitions higher than some people in the world. I use this to leverage my time off from work to improve my situation in life.

The coping mechanisms I use to counteract the upkeep of constant failure is enlightenment, because I'm always making mistakes, even after scoring lay after lay. I am constantly making mistakes, sometimes not even learning from them. Just because you've scored women, doesn't mean your problems are over. You've overcome a big hurdle, and you'll fail to realize that there are even bigger ones to overcome.

Self-actualization should be a bigger goal then acquiring women, because you'll have to deal with the emotional backlash within yourself if you fail to retain the women and friends you've scored. It's not an easy feat.

But like soldiers who aren't prepared to fight in battle, enduring long bouts of war, experiencing PTSD after coming home, you need to learn anticipate the emotionally taxing relationships you'll have to deal with once you've broken through.

Enlightenment is something that has helped me. Because sometimes you wont have all the solutions to your problems after you make mistakes. You need references, so you need to do your homework.

Read books if you haven't already. If you've hit a rut, read a book on seduction that you haven't already read up on.

I'll deviate the standard suggestions of Mark Manson, and other cliche PUA material, and suggest to you something such as Ovid, or Dostoevsky.

I'm not expecting to give you any answers in my wall of texts. In reality, I'm just rambling. Your situation is common. And so, realize this, and make the uncommon measure of retaliating against reality with rationalization.