Controversial Fine Gael member Barry Walsh has resigned from the party's executive council with immediate effect amid an avalanche of criticism over his Twitter comments about party colleagues.