If an employee opts out of being contacted by Retain, does that delete their profile?

No. Opting out doesn't delete an employee's profile. After they unsubscribe, they can still sign in to their Retain employee profile.

Their survey invite isn't deleted either, and they can still take an open survey. For the full picture of what opting out does and doesn't affect, see Can an employee stop messages but still take the survey?