Siri AI on macOS currently understands "turn on dark mode" and "light mode", but it seems it can't turn on the auto mode (switching dark/light), which is the third option in the same menu.
I'll believe Apple have any chances on AI agents once they would at the very least fix that.