Is the game dead?

Absolutely not dead. CS has been around for a long time and it will always have a huge core fanbase. The community, whether it's for workshop maps or creating skins, is large and very active.