Apparently there is a version of post deletion where it can still be seen from the user profile, like the last Will Newsome's post, but it is no longer indexed by search engines. This is just a conjecture, though. I have never deleted my own posts, so I have no experience with that.