Unfortunately it doesn't work anymore for cs:s
I got only black sky with trails. I tried Aurora skies and other but nothing works.
Seems like with valve broke sv_skyname command after steamdeck update, because it doesn't do anything now in css or hl2.