Should you have to quit for swearing?

Bristol politician Gus Hoyt has stepped down after swearing in a private message.
Should you have to quit for swearing?
The late Trevor Fry is to have a road named after him.