I think it's most useful when the opponent is using archers ensconced behind a heavier troop formation. Arrows fired overhead tend to land in a scattered cloud around the target -- the shooting circle has your missile cavalry spinning near the outside of the cloud, in a formation that has a relatively low Surface Area/Volume ratio, reducing the probability that any one unit is going to be hit by the foe's missiles.