I have finally figured out the use case for multi-root workspaces in VSCode. My repository is structured as a mono-repo, but I had issues with VSCode not automatically detecting which virtual environments I used for a Python project. This meant I had to open a new instance of VSCode to get auto-completion and linting to work.
With multi-root workspaces, this detection happens automatically, and I can finally work from a single VSCode instance.