Will csgo ever die?

It might, but that would take a lot more time. CSGO is so simplistic in comparison to some of the other games that it's always reliable to come back to and play a couple rounds, additionally esports is definitely keeping it up as well.
The only way I could see it die in the future is if Valve decided to make a successor. Which they probably won't in the foreseeable future.