We can assume with more-or-less 100% assurance that in past centuries, SSA people with almost zero (physical) attraction to the opposite sex continued to marry and have children. Insofar as the essentials of marriage are concerned, there is no basis to say that the marriages were not valid, and the very idea of revealing this information in past ages would have been a cultural absurdity.
The idea of powerful physical attraction has become more relevant today because as a society, we are hypersexualized, often including even devout & chaste people, either from having a checkered past or by consistently maintaining the goal of chastity but nonetheless being affected and worn down by the surrounding culture. For a homosexual man, the tactile feeling of vaginal sex is no less sensually pleasing to him than it is for a heterosexual man, and a healthy male will have no issue experiencing climax. Of course, there will not be present her visually stunning beauty for him, and although this is easily a great issue of contention, it is not something that makes marriage an impossibility, as it would for two members of the same sex.
In our current age, which has a high focus on the distribution of information and knowledge, it is increasingly imprudent for a person to marry somebody without telling them that they are SSA; exclusively SSA. I confess myself that I feel doubtful I would want to marry a homosexual woman, because the idea that I would not be physically attractive to her in our coupling makes me sad. I suppose that may be a shallowness in my own character, but there it is, and there are far more people that would have far more negative reaction than I.
You can make very strong (and obvious) arguments that exclusively SSA people are called towards generous singleness, or as a religious, or in Holy Orders, but there is no authority to say that marriage as a vocation is barred from them.