My first reaction, was, well, you're right! I can certainly think of a few name players who are well regarded for their playing ability, but I don't think can do a proper double stroke roll.
But then I thought, but really, how many double strokes do ever hear in classic rock?
"White Rabbit" by the Jefferson Airplane is about the only example of extensive use of double stroke rolls in classic rock. The Beatles, Rolling Stones, The Who, etc, pretty much never used them.
Ian Paice, and a few others, of course, incorporated them into parradiddle based fills and other such things, and as noted Steward Copeland has a brief double stroke in "Walking on the Moon". But overall, examples of the the double stroke in popular music have been few and far between since rock supplanted jazz as the more popular form of music. We're talking a handful of examples in what is hundreds and hundreds of songs that have been radio hits or otherwise well known songs in the past 50 or so years.
With the popularity of the Jojo Mayer DVD, and other educational DVDs that incorporate double stokes, I don't think drummers themselves have lost the desire to know how to use them. It's pretty clear they are still something many drummers find useful to know.
But once you join a rock band, how often are you really going to use them? There are plenty of drummers who can shred at home or in clinic or in their side projects, but play it pretty straight in the band they're known for being in.
Side note: Two other examples: On the 1st Pearl Jam album, their original drummer threw in some double strokes on the hi-hat. And Trent Reznor programmed some double strokes rolls on the hi-hat on the first Nine Inch Nails album "Pretty Hate Machine."