Google's account management is infuriating!
First, it almost never remembers what account you used with what service. If I do some Google Cloud stuff under my work account, I don't want Google Maps using my work account, or vice versa. The list of accounts in the upper right corner, and what's signed in/out, seems completely random and broken.
The second problem is that Google's various apps are wildly inconsistent in how they deal with multiple accounts. Some (like Maps) have apparently been "modernized". Others (like BigQuery; I've had issues with Google Drive, too) don't understand multiple accounts at all. It doesn't matter that you sign into a work account. Open that app and it will use some other account.
A sign they've not mastered this at all is that it doesn't work at the URL level. You can bookmark a Google Docs document, for example, and then switch your accounts. Going to the bookmark (or just going back) to the Docs page gives you a "permission denied" error because you're using the wrong account. Same thing with sharing URLs — if someone at work sends me a Google Docs URL, it's bound to not work because it'll try to use what I try to keep as my default account, which is my personal one. Sometimes I just munge the "authuser=1" part in the URL.
It's amazing that a Google app can't simply resolve the union of identities you're signed in as. I have two accounts, work and personal, and one of them has access, after all.
I might consider FF just to work around this.