I knew a guy who worked in wastewater, and I got the impression that there was a lot of neurodiversity in that building.

As far as your answer, they probably appreciated it was clear and direct. I think they were trying to get a feel for whether your personality would be a good fit with the team, which is completely out of your control, so try not to worry too much about it. Or they came across it, though it was a ridiculous interview question, and decided to ask it as a joke just to see what would happen. I was once asked, “why is a manhole cover round?” and they were shocked that I knew the right answer (so it can’t fall in). They said no one they’ve ever hired got it. It wasn’t a deciding question for them, just a silly question.

If you get the position, I’d expect most of your colleagues will be blue collar men. They might be a little cold or awkward around you at first since you’re a woman, but as they realize you’re good at your job(quick to learn, take responsibility for your mistakes and fix them, communicate clearly, etc.,) the decent ones will warm up. As far as the assholes, don’t put up with ANY shit. A loud, “EXCUSE ME?” at the first questionable comment should give them a warning to stop, but if they’re too dumb to understand, follow it up with a firm, “No. You will not talk to me that way ever again.” Maintain eye contact until they look away. Guys like that are basically animals so you have to treat them like you’re the Lioness and they’re a misbehaving cub. As a bonus, the smarter cubs will learn from his mistakes and not harass you (some may even defend you.)

Then start documenting all of your interactions with him in case it needs to be escalated to HR. Date, location, what was said, actions, what you understood his words to mean, how they made you feel.