If you can sign into the same account multiple times that's news to me. Either way, I can confirm that my brother's account that he signed into on my Switch is a different account from my own.
I made a second profile for myself for a second save file in Zelda and it's only tied to the same account as my primary profile.
This shit is confusing as hell though.