Yeah, it seems almost like a perverse point of pride that the weirdos who join Starfleet don't really participate fully in planetside culture, and getting retired from it would almost like a kind of death or imprisonment. Now, why Picard and O'Brien don't get assigned to a cushy Starbase gig in Sol is beyond me. Those two are, mentally, hundreds of (very traumatic) years old each.