Armies have never been presented well in core dnd rules, look at how many mass combat systems have been developed over the years. And again I have no problem with a mass archer unit noted in the book with a 600 foot range “volley fire”, that’s fine.That's fair, but I think armies and sieges and the like are pretty archetypical elements of D&D. And if we look at ways that pcs are so much better than real world humans, I think allowing them a decent chance at landing a long range shot with a bow is far less egregious than letting them walk away from a 100' fall without even being seriously wounded. And in a setting with any kind of magical scholarship, I can't see longer range/siege magic not develop eventually.
YMMV.
As for magic, if you want a magic bow that doubles your range that’s also fine, it’s a dm decision to release that bow or not.
I recognize we have gone around the circle on this topic a lot, so I’ll make this final point. WOTC saw fit to reign in the ranges of magic spells in the interest of game improvements (fireball went from ~550 feet in 3e to 150 ft now), so it’s not like they have just used history to set all the values, but made adjustments where it makes sense. Reigning in bow range is really no different