No, see https://m.youtube.com/watch?v=44KP0vp2Wvg . You're right it didn't scale that well

Looks like it may be capped at 32 cores in that video, if they are hitting 25%-30% of a 96 core CPU?

Here's analysis of a prior LTT video showing 1/3 of cores at 100%, 1/3 of cores at 50%, and 1/3 idle cores:

https://www.youtube.com/watch?v=XqSCRZJl7S0

In any case, CS2 can take advantage of far more cores than most games.