Hello Sandeep, yes, it makes sense, at least in the logic of UNA multi-profiles, he asked me the same problem, the user thinks that by removing his profile, he is rid of the site, because he does not know the multi-profile logic, especially when the site does not use it.

So there is not a bug, the user can delete a profile, but have two more, so it is normal that it remains on the site.
So what I did to get around this was that I hid all the options that only deletes the profile, and just left in options => More "Delete Account".
So when the user deletes his account, he is ejected from the site and all content is cleaned.