Thank you for your quick response.
I would suggest to clarify this in the documentation https://developer.apple.com/documentation/healthkit/hkworkouteventtype/motionpaused
It reads like the settings take effect in the workout events.
Update: I tested this behavior on my physical Apple Watch and the Auto-Pause preferences takes effect on my workout session. With Auto-Pause enabled, the workoutSession transitions into inactive state.