I don't know about steam but if you look at the twitch numbers (which probably correlate more with esport from a pro/money perspective) CSGO does look to be declining since its peak in 2020[0] (which I'd wager was due to some huge event or the pandemic) and is consistently less popular than Valorant.

0. https://twitchtracker.com/games/32399