I don’t think anyone, including the author, thought that the intention of the question was to be transphobic. That doesn’t mean it’s not a transphobic question, though. Especially when the point of the survey was to gauge engagement in Open Source by marginalized people, having such a mistake can be seen as pretty tone deaf, and imply that the company really doesn’t care.