The center of gravity on a galloping horse is further forward than on a horse trotting along or even cantering.
by shortening the stirrups, the jockey is able to be further forward over the horse’s shoulder, moving their center of gravity closer to the horse’s center of gravity. Their seat is not banging up and down on the horse’s back - their weight is in the stirrups, staying more consistent on the horse’s back through the weight transferred to the tree of the saddle. When they tuck down, they reduce wind drag. They loose their leg as much of an aid - that is why the whip is so important when a horse starts to lug out.
Exercise riders, who are often heavier than the jocks, do not use such an extreme position. Some ride with quite long stirrups, particularly if they are on a young, green horse who might add some extracurricular moves.
Eventers ride with quite a short stirrup, but not so extreme - they want to keep their seat out of the saddle while galloping over what may be as much as ten minutes, but they need their legs too.
Forget the motorcycle, get out on an eventing course at a good gallop, and you will soon find out why.
I wouldn’t ride endurance with a short stirrup unless you have bionic knees, though!