Having the same issue, I’ve followed you until this sentence.
How do you actually remove the duplicates? Simply issuing a delete SQL statement in Data Explorer? What about foreign tables records pointing to this tag?
Update 1
OK, I see that you cannot execute update statements.
I’ve now used the GUI and simply renamed the tag.