Mitzi Johanknecht, the former KC Sheriff, lost the support of her troops and the KC Council as noted above and for some other reasons even earlier. The KC Council decided an appointed sheriff would be more responsive to their concerns, and they pushed for the ballot measure. It reminded me of the debate on should judges by appointed or elected since there are good arguments either way.
I believe Sheriffs should be elected. If a jurisdiction wishes to change that to "appointed" via the ballot box, I guess that's their prerogative. My problem with the OP is that, unless I missed something, the Sheriff is still elected by the voters, but if the supervisors decide that if they don't like the decision of the voters, they get to override it. Kind of a slap in the face to people that voted THEM into office.