Ptolemaioi gets cretan archers

[QuintusSertorius]

Then why did the bow become the dominant missile weapon in later times?

There are reasons beyond the mere effectiveness of a weapon that can influence it's popularity.