I think it highly depends on the kind of fame. If you connect emotionally with your audience, then sure. But if, say, you are a famous researcher then I suspect you are facing far less of these problems.
I think his tribe-village-city analogy plays a big part in that, though.
A famous researcher probably wouldn't have as large an audience, and that audience would most likely consist of other researchers in similar or adjacent fields of research
Nope. More famous researchers face the same problems. It doesn't kick until it's popular fame, as far as I know. In other words, if most computer scientists know who you are, you might still be okay unless you get unlucky (but you might definitely get unlucky too). If Joe on the street knows who you are, you've got all this and more.
Yeah, it's very dependent on the kind of fame, as well as the field you're in. A major kpop star/Japanese idol is probably going to have all the problems in the blog article, perhaps magnified by ten. Their fanbase tend to be... a tad less on the sane side, and there are a fair few of them who are absolutely obssessed with their idols and will resort to stalking and harassment.
But at the same time, there are plenty of fields and claims to fame that won't get this. Researchers will get less of it. Someone who doesn't show their face online will seemingly have less of these issues (though people might get obssessed with finding out who they are, ala Satoshi Nakamoto and Banksy). And those focused on more technical/specialist fields may have less issues. Your average popular YouTube glitch hunter or speedrunner will have less problems than a popular YouTube political pundit.
It's not about you emotionally connecting with your audience, but the other way around. And that is something that is out of your control, as this article clearly illustrates. Lots of crazies out there.