We have a Ring pet tag on our dog, however, it seems that multiple users cannot have the same tag. I chatted with Ring support, who confirmed that the tags are limited to a single Neighbors user.
It would be ideal to be able to share the tag (and pet profile) with other users in the same household. I.e. so that myself or my wife could mark a pet missing, get notifications, etc. for that pet.