Can a relationship with little to no sexual attraction work? [23f] and [24m]

My boyfriend and I of over 6 years had been on the rocks for awhile. He was truly my best friend, but I had almost zero sexual attraction to him, and in fact, sometimes he straight up disgusted me. I would go to other guys to fill this void in the form of flirtatious texting, or whatever. I know it wasn't right of me, but moving on...

In the midst of all this, he got a job 500 miles away and moved, expecting me to move with him when I finished up my last semester of school. 2 Weeks later I broke up with him over the phone. This was back in January.

Just recently I've been feeling really torn up about it. I really truly feel like I love him, and I've been missing him. I'm not the biggest fan of his parents... but besides for that, the intimacy sucks. I don't really want to have sex with him. What do I do? Can a relationship where the intimacy isn't good work? Or am I being too shallow?

tl;dr: Not really attracted to my ex sexually, but I'm missing him. Could this relationship ever work?