I use Notion with a non google e-mail and don't mind the password being e-mailed to me. I have to re-auth maybe once a month, tops, and it's one less password to manage.
It is an extremely frustrating practice (emailing you the password). I find that I have to go through this every few days for whatever reason and I've had cases where the email from Notion took five minutes to arrive.
I need to log in every time I close the tab. (For me, one less password to manage is not a concern, I have a password manager for that)