While I don't plan on using this anytime soon it makes perfect sense to have it. Especially on a fetish site like this it's perfectly reasonable for someone to want to delete their profile, even if they're not leaving the site.
"Oh shit! I can't believe I used my real name in my username! What was I thinking?! And I can't even delete my profile to stop anyone from discovering me!"