I’m not a physicist, but it’s not shooting self propelled ammunition. The velocity (therefore force) would be the highest at the launch point and drop due to air resistance.

The minimum range is more of a usability and design issue. It’s hard to aim and, unlike a cannon, has a high release point. At close range it can’t turn quickly enough or aim low enough.