I think you’re mistaking “sexy” for attractive, and those are very different words.

There are definitely people who are sexy, but not attractive as partners, at least not in the long term. Think of how many women responded that they thought Tony Soprano was sexy, and yet how few would find him an attractive mate.