Nature of the charge-density wave excitations in cuprates