Vent about my life.

My girlfriend never wants to have sex with me and it makes me feel ugly and unwanted. I’ve broken up with her before because I’ve told her how I feel about that and what I need (among other issues) and nothing ever changes. We got back together under the assumption she would help try to fulfill my needs, but here we are again at square one. It sucks. She’s great in every single way except this one. I just feel so unloved, unwanted, ugly. She’s very caring and stuff but i do not feel physically attractive or desired by her in any way.
I met a woman 8 years ago online and I love her so much. We connect in every way, our chemistry is so amazing. She lives on the other side of the country though and she has cut contact with me because we tried to meet up and her sister convinced her I wasn’t who I was, despite us talking for 8 years and talking on the phone and sending each other pictures of ourselves and our days consistently for at least 2.
I love my girlfriend to death, but I think my friend is the love of my life. I feel like a piece of shit saying all of this it eats away at me every day. I’ve been in love with her since before I met my gf and I still am. I have not left or broke up with her because we have been living together for 3 years now. I’m just unsure what to do anymore. I feel we aren’t going to last long because of this and it sucks. I just wish she would try more in that area. I have communicated my feelings and thoughts many times only for everything to go back the way they were after 1-2 weeks. I just feel stuck, lost, and unsure about everything. I just have no one to tell and feel so alone.