I think the reason to switch is that Google decided to use the same pricing that they want to get out of enterprises for individuals/families. Sure, $6/user is nothing to a company that is paying that worker $5,000+ per month, but it can be annoying for a family (even if it's still relatively affordable). But then you have to think about whether you want to pay $12/user to upgrade their storage making it $72/mo for a family of 6. And you still don't get the Microsoft Office apps. They aren't strictly necessary in a lot of situations, but they're still pretty commonly used.
It just seems like Google isn't offering great value for individuals and other companies offer something better. In a certain way, it feels like Google is charging $6/user/mo just for the custom domain. With Microsoft 365, it at least feels like you're getting something above a standard account with the Microsoft Office apps and 1TB of storage.