I think it’s perfectly normal to expect being attracted to your partner. I can’t imagine being intimate with someone I am not attracted to. But it does not mean people need to be gorgeous. You need to feel attraction which typically comes from within when you are connected to a person. I don’t recommend you force anything.

Is that a relationship from 10 years ago? Have you tried to date since? Are you seeing a therapist?