If a member account is deleted before the posts are deleted, you have to manually locate and delete the posts individually.
However, you are under no obligation to do so - the content belongs to the site and removal can only be enforced if it relates to GDPR or whatever laws govern your particular installation.