Cooper-pair localization in the magnetic dynamics of a cuprate ladder