Not to get too particular
I think "solid" in this case is the wrong choice of words by WotC. In reality, there is nothing in rope to shatter, so it would have no effect. Crystal, gems, and and other material that has some kind of rigid, fixed molecular structure could be shattered. Glass...