The lives of a number of people have been severely affected by an ex-Garda Special Branch member who caused death and serious injury to others while drink driving, an inquest has heard.