This is why Mike says you can't just delete data from the database.
There is a lot of data which is maintained across multiple tables. So each profile post comment has its own entry in the xf_profile_post_comment table, but then there is a column in the xf_profile_post table which stores a cache of the number of comments that profile post has.
You have deleted the comments, but there is nothing that will trigger those counts to be updated.
The same applies to everything. If you delete a post from the xf_post table, it does not rebuild things like the message_count of the thread or the user, or the forum, or remove likes, or remove edit history etc. Running queries like that on your database, just as Mike says, without understanding the consequences, is not at all recommended because this is the exact problem it causes.
So you really should look at restoring that data from your most recent backup and then deleting the data properly.