Claiming that something cannot be said in Trek because it runs counter to military tradition is just plain crazy.
I would never call anybody Sir by the way, it is a stupid word from aristocratic times and deserves to die out.
You clearly don't live anywhere near the South (US). Most people despite of age use "Sir" and "Ma'am" as a sign of respect. Nothing 'crazy' 'bout it, just being courteous.
It's a stupid word from aristocratic times. Strange that you guys in the US who got rid off monarchies earlier than European on average cherish such non-egalitarian language.
Furthermore what you said is simply wrong, sir is often used as formal way to address somebody and doesn't imply any respect.