This is very personal. I moved in with OH (widower of 17 years standing, then early 70's) because I loved him. We both hoped that a full relationship would ensue and tried for that. It proved not to work. We don't know why, possibly medication for a triple-heart-bypass.
He's not that sort, but he even bought some pornographic stuff to see if it would work - no. I can't say that I wasn't disappointed (to say the least).
You want honesty? I had to think about if I preferred to be with him or without him and how I would cope without sex. I have discovered that you can have a very passionate relationship without physical sex. He is a very passionate man, although I don't have any expectation that physical love will suddenly become an option. We are in a deeply loving, happy relationship and we got married last year.
The first realisation was tough, though.