Do people still play CS GO?

Of course, it's still pretty popular. And I believe that if you decide to join a server there, you'll find many people.

 

I agree that it's not a problem to find many players there, and I can tell you that playing this game can also be pretty profitable. If you're interested, you can just earn skins like https://dmarket.com/csgo-skins/product-card/awp-paw and sell them for a good price, and I believe you won't have any difficulties making money that way.