You can have both a gmail and a google workspace account with the same email, but I'm sure someone can do better than Google.
Also I'm pretty sure that since google is itself an SSO provider, this add another layer of clusterfuck that I don't even want to think about, regardless of whether there's a clean implementation or not, I don't even want that on my mental capacity.
If they do it correctly, that shouldn't be possible.