Being attractive is subjective. Not everyone is going to think the same people are attractive. That being said, there will definitely be people out there who find you attractive. You’re not going to find a relationship if you look for one. Once you stop looking, youll find someone.
A conversation definitely needs to be had. This isn’t on you, as you want both sex and children. You need to ask him WHY he doesn’t like sex. Sounds maybe a bit suspicious to me. Have an honest conversation with him, and hopefully, you can work it out. If not, then couples counseling may be the only option left.