It seems like I can' replicate this issue on your site.

When I trying to click the sign in via Google from the Joomla login module on the right position, it shows me login successfully and I can able to access my profile link https://munawwarah.net/arlex-wong .

Hi Arlex,

Thank for your reply.
Just tested it again and looks like it works well only for newly registered user.
If we delete the user from backend, then user register again with same Google account, then user will get an error to view their profile.

Okay, I can replicate this issue, when the same user sign up on the site again, the system doesn't delete that deleted user account all the SEF URLs so when the same user email register on the site again, the system will reuse the deleted user SEF URLs (contain invalid user id) so caused this issue.

In order to solve this now, you have to purge the SEF URLs from the Easysocial backend so that system can regenerate the correct SEF URLs on the site.

By the way, this issue only happens when you set SEF Urls To Use IDs to NO, I will log this issue into our issue tracker and see if we can find a better solution for this.