In short, no. The predominant audience for mass media are the same masses that care about the Kardashians.
That said, there are aspects of sound design that are being noticed. I've often half-joked that if I do my job right, nobody knows I'm there (noting that I mostly do live sound reinforcement, where there are fewer expectations to meet). It's getting harder to pull off the perfect unnoticeable audio edit... but on the other hand, the trend is now to have nearly-constant background music, so many of my mistakes can be covered.
What people notice more today are the cuts. Most audience members still won't notice that a particular bird call won't be heard near a particular tree, but they will be more likely to notice if an actor's voice changes between scenes. The old practice of having a professional singer dubbed over an actor is more difficult to pull off now, mostly because the audience is aware that such things are done. They hear the opening notes of the song, and it's become a game to hear the voice change.
I think the Wilhelm scream is also a great example. I simply refuse to use it. Especially with the influence of the Internet, the common effects are becoming a sort of secret society. Learning the clips and catching them in media is a moment of exclusivity. For just a moment you, the astute viewer, are immune to the effects of manipulative editors like me. Good for you. You've proven to yourself that you can still override your suspension of disbelief. All of those other silly folks in the theater are engrossed in the latest multi-million-dollar effects orgy, but you are better than they are, because you can see that the movie is just smoke and mirrors.
Yes, the squealing on gravel is still present, but gravel in general has fallen out of use, apart from period pieces (which wouldn't usually have cars, anyway). Most of the shows I've noticed lately have urban settings, or at least try to stay out of the dirt. It's hell on equipment, and gravel roads are rare enough today that it no longer breaks suspension of disbelief to see a country town with pavement.
In not-so-short, audiences are becoming more knowledgeable about the tools editors use, but I don't see them getting "smarter" about being able to notice equalization, mic placement, or most other things besides the obvious overused clips.
As I view audio as an art form, I also disagree with the very use of the term "smart" as you've used it. Appreciation of an art form, imperfections and all, is just as intellectual a pursuit as identifying regional bird calls. Should we call Michelangelo a moron, because David's hands are too big?
My comments are also getting to be far too big today...