Hundreds of cases of potentially homeless people, including domestic abuse victims, were dismissed by a council which has apologised for “failings” in its approach.