A councillor apologised to residents moments before approving a controversial application for 99 homes in a village.