Chris Noth’s talent agency has dropped him following allegations of sexual misconduct