As a woman with that level of enthusiasm about niche science info (I got a degree as a science communicator, because I literally can’t help myself sharing interesting info when it seems a good time to do so)…
It’s very very difficult to find people who aren’t intimidated by it, or put off by the enthusiasm about something they don’t begin to understand/care about. Of all the people I talk to randomly, maybe 1 out of 30 people actually likes the enthusiasm past the first 5 min. And even that 5 min can be a stretch. That is to say, they tolerate it, they don’t tend to engage with it or encourage it. Mostly you get “oh, that’s neat”. Which is a great way to shut the entire conversation down, cuz where do you go from there?
I tend to agree that enthusiasm is interpersonally attractive, it’s why I make small talk by asking what thing the other person finds interesting that they learned recently. (Not something they think I want to know, something they are interested in). I don’t think the majority of the population views it that way, though. They only think enthusiasm is good if it’s a subject they already care about in some way. And they don’t want to share theirs in case it’s not something you are interested in, even if all you actually are interested in is whatever sparks their passion.
I guess it could be my area, but I’ve been a lot of places (mostly within the same country ofc) and found about the same whether rural or urban, north or south. Also I don’t think my observation is because I’m a woman, but it could be a contributing factor, idk.