CS2 does indeed look much better than CSGO, but... It's essentially looking like a reskin with a twist on smokes. Until they unveil their new AC (If they even have a new one) and their new MM system, nothing's looking too wild. If the game plays the same (God bless the Valve devs if it doesn't, because the CS player base will tear them to shreds), it still remains CSGO at its core.
Anyway, I still find the CS2 release to be great for Valorant. It'll get Riot sweating a little bit, so we should see a wave of new features and a greater release of content sooner rather than later (Valorant Replay System incomingggggggggg). Plus, it'll make the community feedback much more important. Can't be complacent anymore when your biggest competitor has now released their biggest update in a decade.