As title says i can't delete my account when i hit "Yes! delete my account" button working incorrectly just logging out of my account.
When you click Delete Account, the account is deactivated (It will appear deleted, but still present on site).
The actual deletion happens 14 days after the request day, after that the account is deleted permanently.
When account is deactivated but not yet deleted, you can still login into it, which will cancel the deletion process and re-activate the account (this is in case user change their mind).
You can verify this by coming back to this post after deleting the account, it will say "Deleted Member".