As an SF resident, I can say that every light rail line sees heavy use by locals.

I think oblio is confusing SF's cable cars (historic and almost exclusively used by tourists) with SF's light rail/streetcars (quite modern and used by everyone).