The safe default
Ship no motion, then add motion only inside the media query. That way a browser that does not support the query gets the calm version, which is the safe direction.
What reduced motion does not cover
It does not cover parallax, auto-advancing carousels, or a timer that forces an action. Those need their own pause controls, and the media query is not enough.