When removing the last use of a tag, usually a database trigger removes the tag itself from the tag table. The appropriate triggers are missing from event_tag, place_tag, recording_tag and release_tag, though, so if the last use of a tag is on one of those entity types, the unused tag will be left behind.