Will CSGO ever die?

Very unlikely. I'm not sure if valve is going to release a game in the future, even if that happens CSGO will still be very popular, like 1.6 is now.
They made it free to play, and have put a lot of effort into updates lately, if they keep doing that CSGO will say alive for a long time (unlike Fortnite).