Just like if someone showed up drunk at work, showing up with an unacceptable behavior should be seen in a similar lens.
Noone is saying it's acceptable, just offering advice on how to mitigate the situation.
Should is the keyword of your last sentence. In a perfect world sure, but the world is not that.
You never know, you may even become friends. Doesn't hurt to attempt once at least.
You are not there to win a popularity contest but to articulate what is needed clearly, keep people focused, unblocked and to get things done.
If you worry too much about being liked by everyone your mental health will suffer. You just have to accept some people won't like you.
Also comes across as insecure and less fit for leadership roles.