I’m not denying that ace spectrum people have relationships and settle down as well. But OP is asking about the normative (read allosexual) experience and explicitly mentions physical attraction.
I don’t think this only applies to ace people. Sometimes you just realize you can’t have everything, settle with someone “below your standards” in respect to that, and even if you sleep in the same bed, you don’t do anything with each other in that way.
Thing is, sex is not a privilege. If you - as someone in such a situation as OP - can’t accept that, you are in danger of growing… hateful views. I don’t want to become such a person, and it’s clear that it’s not their fault that they are not attracted to me. Realizing this helped me accept it.
To be totally clear, yes, I’m not ace, I have the desire, but that’s just not how it works.
There are still other benefits of having a partner, like not being lonely and sharing the costs of living.
To also respond to OP, I don’t know if this is “the solution”. This is better for everyone involved than the alternative where you grow to be a hateful person. But maybe you should reevaluate if you are really in such a situation as you think. Possibly you are right, possibly not.