Manny Aguirre’s bar-side manner has soothed generations of Hollywood’s elite