I'll tell you all now. This is bullshit.
There isn't a new version of CS coming anytime soon. What's happening is CSGO will be moved to Source 2 Engine. This is not a new game, it's 99% a backend change to move the game onto the most up to date source engine.
It won't look any different, it probably won't even feel different. It most certainly won't be packaged and released as a new game either.
In fact, CSGO will probably get slightly worse (in the short term) due to new bugs associated with being on a new engine while they need to fix things.
We are still many years away from a "new" counterstrike game. If you think the current game running on a cleaner / more up to date engine, is enough to cause an exodus from valorant, you are smoking heroin. It is NOT going to be a new game.
I love CSGO, but those guys are just talking out their asses.