Loading the shaft properly during the downswing becomes difficult when it is excessively stiff. Even unloading is difficult. As a result, the clubface remains slightly open, and you wind up slicing the golf ball. And when it isn't rigid enough, i.e., when the shaft flex is too flexible, it opens the door for all sorts of misses (low and left, high and right, etc.)