Frame rate and optimization issues currently leave CS2 anything but playable on Steam Deck, but it appears that Valve is working quickly to fix things.
It runs surprisingly well hooked up to a monitor using keyboard and mouse. It's not beautiful or high FPS z but it's playable.
Only issue I am facing is that I don't see fog or fire unless I am standing inside. I can just see through it.