Althogh Sparrow supports non-GMail protocols, it really is primarily for GMail. I use a standard IMAP-mail provider (folders, not tags), and to me Sparrow added very little over what I had with Apple Mail.
(Conversly, when I used GMail, it didn’t work that well with Apple Mail.)
It's my impression that Sparrow is intended primarily as a GMail client. I don't have data, but I'd be surprised if a significant portion of its users didn't have GMail.