I've been an RSO for the better part of a decade, and the Chief RSO for the last 4 years. In that time, I've "pulled cards" on probably 10 people who had to go to a board review. In all but one of those cases, the board dismissed the members and declared the persona non grata and ineligible to ever reapply for membership. The other case... he was forced to attend new member orientation again (after being a member for 15 years) and permanently lost access to our indoor range.
It's not easy policing idiots who don't want to follow the rules or have such serious lapses of judgement that they simply can't be welcome as a part of the organization.
Edit: I should also point out that we're a club of just under 2,000 members, so pulling 10 cards is really an insignificant percentage of the membership.