When you delete one of your profiles, you end up at this page:
After clicking the blue 'Join this community' button in the top bar, you'll reach the Confirm Your New Account page:
After confirming, the account was recreated but I was redirected to this page:
which gives a 404 Page Not Found:
It happens on more sites, not just Stack Overflow. If I join from the homepage, it works fine.