The lead investigator in the Karen Read case has been fired after admitting that he sent sexist and crude texts about her to family and colleagues during her trial.