Syllabaries are great if the language has relatively simple phonotactics. Once you start having things like triple consonant clusters or a dozen different vowels, it breaks down pretty quickly.

The other thing that makes alphabets more popular in the long run is that they spread easier because they're easier to adapt to different languages compared to syllabaries (indeed, it's not uncommon for a syllabary to become semi-alphabetic as part of such adoption).