I think the Ripken one is known by everyone, partly because it's more recent but also because it wasn't celebrated as some amazing athletic achievement. It was just a guy showing up and doing his job every day for 20 or so years. I think the common man really took to that and found some appreciation in it (even if the common man has to work 12 months a year and Ripken technically only "worked" for around 7-8 months or so).
This..
The problem with most of these is very few know the number.
Almost everyone who knows about Joe D's streak knows the number: 56.
It's the most famous sports streak, by far.
Well yeah, barely anyone knows the exact number of any of these. But I didn't think the question was about the actual number but rather the actual streak as an event. I could be wrong though.
ETA: I think Joe D would be #2. Baseball lends itself to streaks and such, due to the long season, playing just about every day, etc.