Yes, exactly, a workspace for each one of those. A snippet from my Aerospace config:
[[on-window-detected]]
if.app-id = 'com.microsoft.teams2'
run = 'move-node-to-workspace 7'
[[on-window-detected]]
if.app-id = 'com.hnc.Discord'
run = 'move-node-to-workspace 8'
[[on-window-detected]]
if.app-id = 'com.spotify.client'
run = 'move-node-to-workspace 9'
They're 'persisted' in the sense that when I open them, they automatically open in their relevant workspace. You can also make them auto-start, so when your system boots up, they'll be in the right place.
Do you use iTerm2 or Terminal.app, and tmux?