A lot of beer is one dimensional. A lot of lager. A lot of IPAs. Sourness is one aspect of a beer, like bitterness is. I'm a huge Rodenbach fan, it is a mixed fermentation beer with a lot of complexity, but I also like other types of sour like Berliner, Gose, and some fruit sours. Simpler, but great on the right occasion.
Sours are an acquired taste but when you acquire the taste these beers are often fantastic. There are sours that are too much for me, I drink a limited range of them, but experience suggests the more of an intense thing you eat or drink, the more tolerant you become of the intensity. Curries and chillies, IPAs etc. My appreciation of sours is expanding, slowly, cos I drink them occasionally. Some of the most memorably great beers I've had have been sours.
I agree with you that different beers are good for different occasions.
Whilst I like sour things I guess it's just not my favourite flavour profile. Horses for courses and all that. There are certainly some excellent sour beers I've enjoyed, but they are a tiny minority of the ones I've tried and they are beers that offer some subtlety beyond the sourness. I don't necessarily think simple should mean one-dimensional. What I mean is many commercial sour beers taste one-dimensional in the sense that they don't really taste like beer to me, more like a tart soft drink or something. And the shelves here, in the US, are groaning with brands like that. I just feel like breweries lose sight of what they're doing, dialling one thing up to 11 because that's the cool new thing. Some breweries do very good sours, no doubt, I just need to keep trying until I find them. I don't mean to say sour beer as a whole is bad. Maybe I should say sour beer is suffering from overpopularity.
I suppose in the same way many good lagers were (still are) pushed out of the way in preference for fizzy, one-dimensional, often crap tasting stuff, because Pilsner-type beers became the thing all brewers wanted to make and drinkers wanted to drink. Same for bitter too – Watney's Red Barrel, anyone? The good examples of lager and bitter are excellent, they can be more or less complex, or simple but nuanced. I wouldn't say one-dimensional.