My wife, at least once this week (DVDs and books). Me, once this week and probably tomorrow (to get out of the home office for a bit, and maybe a book). Pick any random day at any random time the Redmond, WA King County Library is open, and the parking lot will be a minimum of half full. Weekends or after work/school it's probably close to full.
That's not counting the eBooks that don't involve going to the b&m library. Overdrive worked, but was generally a PITA. The Amazon setup, all other complaints aside, was surprisingly low-friction. If I like the book and might reference it again, Amazon has a convenient "buy" button when going to check it back in (yes, yes, evil corporate bastards).
In summary, it looks like plenty of people use our local library. I don't know why anyone that consumes books, CDs, or DVDs wouldn't at least pop in to see what it's about.