Likely depends on where you live/shoot.
I shoot at various BLM shooting spots in two states and while I always pick up plenty of 9mm brass, sometimes I pick up more 40S&W brass than anything else. And of course, there's always plenty of .223/5.56 brass and some days, I pick up more .223/5.56 brass than anything else. .38 Spl/.357Mag/.380Auto/45ACP brass make up the rest of my pick up brass.
Interesting thing is I notice most of these brass are factory new/once fired with plenty of factory boxes present at the shooting areas. Can't imagine people shooting that much when ammunition was around $1 per round.
40S&W is certainly not dead based on the spent brass I pick up.
I hardly ever pick up .357 Sig brass so to me, for areas I shoot at, .357 Sig is near dead. Heck, I even see 10mm brass from time to time.