No it adds variety to the look of writing, each character is a syllable not a single sound (mostly) so they use fewer characters for per syllable, having two syllabary systems means that there’s more visual distinctness per word. I’m not a Japanese speaker so don’t take my word for it, but no they’re very much not stupid it’s a clever system and one that’s related to the history and culture of Japan.