I think it's important to grant some precision concerning the question, so let's break it down a bit.
Initial Concerns: I would imagine that the main terrain on which this debate operates, at least in the first instance, is one of i)
psychology and ii)
intention, which I group here as they overlap considerably. i) is a concern regarding whether a person, consciously, unconsciously, or non-consciously hates, fears, or has some particular negative disposition towards trans people. And ii) is a concern regarding whether the utterer of a statement intends to voice or propagate such a view, or harm trans people. Let's break these down:
Psychology: We of course cannot be certain, without any other evidence, I think the principle of charity demands that the statement in question from Horus Heresy was not one made by a person whom we have reason to think of as a transphobic.
Intention: The principle of charity similarly demands that we don't read this statement as such, again, at least without further evidence.
Accuracy: The next issue is a matter of the
accuracy of the statement, and particularly it's reflection of the biology of sex. Here I begin with a story. In 2019 I was asked to help teach a course entitled The Philosophy of Sex at the University of Sydney, an area of philosophy with which I was unfamiliar (but I needed the money). It was a great subject, and one of the most enjoyable was given by Prof. Paul Griffiths, who is an expert in the Philosophy of Biology, and has published a considerable amount of work on the biology of sexual difference. His lecture was an anomaly, as it was not one with the intention of imparting any knowledge regarding the biology of sexual difference per se, nor one aimed at engaging students in any particular philosophical issues in this area (although other courses were available). Instead, this lecture had one goal: to demonstrate how little we all know about the biology of sex.
We laymen know nothing. It was a tour
de force of the most complex biology I have ever encountered. The purpose was to take as a foundation that our discourse on this matter must emerge from a recognition of our own thorough ignorance of the biology of the matter, such that we do not lend baseless dogmatism to our thinking about this. A link to a popular presentation of his view is here:
https://www.appliedphil.org/sap-public-lecture-australia-a-process-theory-of-biological-sex-paul-griffiths-university-of-sydney/ To summarise his position (and I may be wrong, here, so forgive): a) there are only two sexes; b) not all individuals possess one or the other; and c) for the most part, sexual difference, from a biological perspective, is more a species-level issue than an individual-level issue.
Initial Summary: From this, I think it's fair to say that the statement in question expresses a primary-school level understanding of the biology of sex, and is properly distortionary of the reality, and it is highly unlikely that this person made this statement from transphobia, or wielded it to transphobic end. But I think that there is one more point to make.
History: Whether we like it or not, and regardless of what our own intentions and psychology may be, it is the case that language has a history. Indeed, as Wittgenstein argues, it's necessary for language to operate as language - to communicate meaning - without this. That is to say, the meaning of the words, terms, and phrases we use has significance over and above our own use. So regardless of how the phrase in question was used, or was intended to be used, and what it was intended to communicate, there is a separate issue concerning the discourse(s) with which it engages - intentionally or unintentionally. And I think that the writer of the article has a point: It may not have been made as a hateful statement, but it is one that intersects with, and strongly resonates with, hateful discourse. Discourse evolves, and maybe the pseudo-scientific transphobic discourse with which this phrase resonates only arose
after this claim was published. But we cannot deny the reality that it intersects with in now, and it is a discourse which does genuine harm to trans people - a vulnerable group even in the most progressive societies; a group over which hangs the very real possibility of death in less progressive ones.
Conclusion: Given this, I would argue that we have sufficient reason to state that the statement from Horus Heresy
is not transphobic, but that
it should be changed, because of the harm that it does. Like it or not, we have a responsibility to counteract the efficacy of hate groups when it is within our reasonable power. And one of these needs is to be a little more careful concerning our expressions regarding the biology of sex, lest we not parrot the distortionary speech of hate-groups. This would likely not demand that
GW recall all these products form those who bought them. But it would demand that they change this, and related statements in future editions of this book, and future publications.
EDIT: Furthermore, I think that we as a community of wargamers have certain responsibilities to be as inclusive as possible. This may not demand that we write to
GW to demand this change. But I think it requires us being receptive to concerns that emerge from the community. And in a way that has been unfortunately lacking in this thread, which has been overly ready to speak of 'snowflakes' and 'virtue-signalling', and characterise this as a non-issue, or one over which we should pass in silence because its 'divisive'. This means saying (and remember, you don't have to say anything at all), not just "no", but rather, "I understand that we are dealing with legitimate concerns of a marginalised group, and whether I agree with this statement or not, we are an inclusive community."