Rather than comparing it to real life military I would compare it to astronauts. I would think they'd be at the very least mini-celebrities. Debatable evidence: Picard being almost thrown a parade in Family.
If military people IRL were regularly making first contact with different species I think people would know some personalities... unless it was all classified. In that case a lot of people would dislike starfleet.