in general people in NA don't play cs at all. The game has around 40,000 concurrent players in a 300,000,000 person country. It's not really that people are going from CS to Valorant, tons of people are going from games like Overwatch, Fortnite, Rainbow Six, and COD to Valorant.
There aren't any official numbers for the concurrent players in NA for Valorant, but just look at the streamers, the biggest NA cs streamers at most get maybe 3,000 viewers, and streamers like Hiko are pulling in 20,000 viewers on a regular basis.
The issue isn't people switching from CSGO to Valorant, Csgo is just irrelevant in NA because the game has a small player base, rarely advertises, and is one of the worst games for new players.