NYPD detective faces backlash after appearing in a rap video wearing a G-string