FWIW, you can disable the "Automatically rearrange Spaces based on most recent use" option in the Mission Control Preferences panel.
Reported to Apple, "works as intended". One more reason to never use macOS' built-in fullscreen mode.
I'd imagine the default is meant to function more like iOS