Sadly, we've had to face this a number of times at WikiTree.
If we can't contact a family member who can take over private profiles, they need to be deleted. However, public and open profiles can stay on WikiTree. These profiles are "orphaned" and become open for adoption by other members.
If there is a particular case, e-mail Tami at firstname.lastname@example.org.