Tory councillor Terry Mendies' comments were blasted as 'discriminatory against women and wholly inappropriate'