It's a big deal to delete a profile on Wikitree, and is highly discouraged. If you're no longer around to manage the profiles you created, they will be orphaned and adopted. There are lots of orphaned profiles in Wikitree. When I run across one, I try to improve it a little, either by adding a source, or adding to the biography. Occasionally, I adopt one and hang on to it for awhile before I set it free. So when you die, your profiles won't be deleted. They'll be here for someone else to work on. Since we're all ultimately related, someone will care.