I am actively working on testing code to try and reproduce what happens in these situations when a remote server does not unsubscribe from communities. Doing a direct SQL delete of rows from the persons table is perhaps out of scope, but there is a lot of cleanup. There was an explosion of instances (new servers) out there and many have since gone offline. So I am sure the the topic of how to clean up old orphan data will keep coming up.