If it's any consolation, the Windows version runs on macOS Sonoma, but you need to use Whisky to install Windows Steam & launch it from there. Also, you need to adjust some graphics settings that can only be adjusted using the command line, or the frame rate will be unplayably bad.

I feared that CS2 would use some kernel-level anti-cheat solution, which would prevent it from running on macOS, but it doesn't.