"Chill out! It's just a joke ad!"
Ah, yes, the "it's only a joke" defense. This has been used to try to excuse every brand of idiocy and bigotry there has ever been. It is never a convincing answer.
"how is 'does anyone actually like
VBA?' insulting?"
Try "does anyone actually like Microsoft Windows?"
The phrasing of the ad's question implies that it's self-evident that nobody really likes VBA, which is a complete falsehood.
As to those who prefer language X and hate VBA, as I said in a comment, I'm gay, which means I prefer men, but it doesn't mean I hate women. Preferring Python or whatever language you enjoy working in does not in any way suggest that you should also "hate" some other language. Mantaining any "hatred" of anything requires a lot of emotional energy and I don't quite understand why anyone would defend something so counterproductive.
Don't like it? Don't use it! Mazel tov!
In fact, most people don't enjoy working in languages that they aren't familiar with, or that use different paradigms for problems they've solved in other languages. This doesn't justify hating the language. It just means that for you it's more work to program in that language.
It seems obvious to me that the ad is counterproductive (it's popping up for the people least likely to hate VBA, i.e., the people who use it all the time), but given that it's based on denigrating a programming platform, I don't think it should have accepted by SO in the first place.
And I doubt there's any other language for which it would have been accepted.
"most people hate working with VBA"
This is an assertion without any basis in fact.
If SO has a policy that VBA is not a real programming language, then it should prohibit posts on the subject. If that is not the policy, then this ad should have been rejected.