When I'm on some site and want to quickly search the web using Google (when DDG isn't enough) on the same tab and then return back to the site, or if I use a container temporarily to check a Gmail account, I don't want to mix those up by mistake later (I never search on Google while logged in). This problem may not exist if I spent time to pre-decide the use/assignment of websites/accounts for each container.
Since I also use sites like HN to jump to other sites (several of which may be trying to track), auto-deleting cookies gives me peace of mind once I close a tab (I set the timeout value in the extension configuration quite low). I was using Self-destruct Cookies [1] before (when legacy addons were still supported on Firefox).
For additional protection, I do some more extensions.
[1]: https://addons.mozilla.org/en-US/firefox/addon/self-destruct...