It's definitely not only a very different flavor, but also a very different
type of flavor from, e.g., a strong, hard-hitting IPA or a crisp, clean pilsner. I'm betting there are a lot of fans of sour ales out there right now who have absolutely
shit taste in beer in general, and probably a whole lot of guys who have excellent taste in beer and really can't stand the taste of sours. My understanding is that much like the bitterness of a nice, hoppy standard brew, the tartness of a sour is an acquired taste that isn't naturally appealing, at first, to most people. If you enjoy snacking on some nice green olives, you'll probably love a good sour - in the same vein that if you enjoy sipping on a good IPA, you'll probably love a good pilsner.
I'm probably not the
best person to provide a sense of perspective on this, in that I never had to be conditioned to like really tart flavored stuff because I always naturally had - to the point where I started making my own yogurt as a teenager, because I could make it a lot more sour tasting than any store-bought variety. (And because it's really cheap and easy to do.) Like most people, though, I
did have to be conditioned to appreciate a decent hoppy flavor. A large and diverse array of terrible and shitty beers were consumed in the process but, hey, worth it in the end. Now I can drink a really good beer without fundamentally wasting it, for one thing.
I was introduced to a few bottles of sour ale (from Belgium or whatever) that I really enjoyed a few years ago, which impressed me enough to get me to go out and try to find some more. Ended up wasting a whole bunch of money on a pack of something different but allegedly comparable at the time, which I didn't like at all, and that experience basically caused me to mark off the whole thing as being not worth the bother until recently. (Especially since I was much, much poorer back then, and paying more than 3x the money for some 3.5-4.5% ABV brew, than it'd take for me to make my own >6% ale, just did not make sound fiscal sense to me.)
Now there's a bunch of good to decent local options, they're much cheaper, I have money for them in any case, and rather than commonly hovering at some 3.5% like what I used to see, the new microbrew sours I've come across lately have all been one of: 4.5%, 5%, or 6% ABV* so far. So yeah, I'm kinda digging this fad right now.
EDIT: Forgot to mention. Before posting this, I went off for a bit of an experiment: My mother and brother both very much dislike the taste of beer, and so I pushed some
Orpheus Serpent Bite, a moderately hoppy plain sour, on them. Mother's assessment: "[Yuck.] Bitter. Sour. No redeeming qualities." Brother's assessment: "It's pretty good...interesting." (Readily accepted a second.)
The more you know.
*Pretty typical range. If I want something stronger than 6% these days, I'm obviously trying to get my drunk on pretty quick - might as well just get some liquor instead of halfassing it with Hopsecutioner or some other especially strong brew. If I want something weaker than 4.5%, then... I'll just have some ginger beer, I guess? I'm obviously not trying to get a buzz going anytime soon.