Heh, that hole left by the missile (if it is one, on the right bow) is no shoulder fired weapon, that's for sure. Looks more along the size of the holes made in USS Stark and other ships hit by that size of anti ship weapons. Pretty badly damaged, it's amazing what they can fix, but that is going to need a LOT of fixing.
Besides, it was (and typically is) the fire that killed that ship, and fire is usually from the leftover fuel in a missile, something a shoulder fired rocket doesn't really have. Seeing the video and how quickly that fired brewed up, I can't believe that an explosive would have set other combustible stuff about into such a raging fire so instantly as per the video - that was absolutely IMO from leftover fuel from a missile, again something a shoulder fired weapon like an RPG doesn't have, or at least not much of. HMS Sheffield burned up and that missile's warhead didn't even detonate, just fuel.
Plus, looking at the vid in slow motion, it was launched from some land based platform similar to what the land based Silkworm types look like, and other ASM land based platforms.