Is buying CS skins worth it?

Depends really, if you can justify purchasing virtual skins then go ahead. Keep in mind that CS:GO's playerbase is quite stable, so if you're worried about losing money on a dying game - dont! If you have some valuable items for other games that you don't care much for go ahead and join a trading website, see if you can get the skins you want by trading your unwanted items.