Containers are useful for separating "who I am to my providers." As far as Facebook is concerned, I am a Facebook user, but I don't use Amazon or Google. But Amazon thinks I'm an Amazon user that doesn't use Facebook or Google. You can accomplish this with profiles, but in Chrome (last I checked) that meant multiple windows, rather than just sites being displayed in tabs that indicate the container in use. So for that purpose, I believe containers are more useful.
(I also think Firefox should step up their profile game, because when my spouse and I alternate using a computer we share, it's inconvenient for me to close all her Firefox windows so I can open my profile!)
Go to about:profiles, click the "Launch profile in new browser" button under the profile you want.
Yes, it's not obvious, and the UI has a lot to be desired if you want to explain the feature to some non-techie, but you no longer need to close the other Firefox instances in order to launch a different profile. I think this was added a couple releases ago.
So in your case you could have say a "work" container and a "home" container. Each of these could persist logins for all of the services you are using without having to switch between users and have different windows open you just have the 2 tabs.
What I think people find more useful is the ability to make a container for say "facebook". Anytime you open facebook it puts it in a new tab with a sandboxed browser session. It's similar to having a separate profile but it's just for facebook use and you don't have to think about it so much. If you click a link to facebook it opens it in your new container already logged in meanwhile facebook does not see you as authed in any of your other tabs.
Instead of you needing to know all the tricks and tweaks needed to make it work well, they're in the box.
I don't even know it's there until it does something unexpected but necessary. For example the Facebook Container has no idea I pay YouTube not to show adverts. So inside Facebook any inlined YouTube video has adverts. If I follow a link to YouTube, I appear outside the Container and have no adverts but don't get followed by Facebook (they'd need YouTube to co-operate)
Having a container is nice compared to opening a private window because you don't have to do 2FA every time.
It's definitely something I'd like to see worked out better as a power user feature.