There are two sides to this - historical reasons for transposition and usefulness today.
The history's a given, even if there's some uncertainty in places. No point in arguing about it, unless it's to clear up uncertainties.
Relevance today? For me and many others act is that it is relevant, for many of us challenged mortals who like to make music, but aren't willing (or able) to learn different fingerings for each written note. I'll never play the clarinet - not because it's different to blow, but because there are different fingerings for each ntoe, depending on which register you're playing in.
Even a system that's clearly superior - such as Boehm's flute - takes a long time to gain acceptance as existing skills have to be unlearnt and replaced with new ones. It was ease of playing - and superior tone in all registers that eventually caused Boehm's system to be adopted almost universally.
Another issue is that the different members of a transposing family have different sounds - and the C Melody sax is an example here. It doesn't have the guts of the Bb tenor (even though it's only a tone deeper) and doesn't have the sweetness of a good alto. We need those different voices. Just as the classical composers scored separately for oboe/cor anglais for example - it wasn't just the pitch....
It's like many other things - you feel that you can improve things because your way works better for you. But if it doesn't offer a clear advantage that'll cause the majority to say yes it's worth the effort to change, it'll never take off. Personally I see few benefits, only drawbacks.