Not at all, for example at secondary/high school you would address male teachers interchangeable as ‘sir’ and ‘mr. Last name’.

Pretty much.

Used outside that frame it’s an insult as in:

You, sir, are a cad and a bounder.

Uh, no it isn't.