It would have had more impact with me if I cared about any of the characters that died. The mother was annoying and Robb seemed like a buffoon. Snow needs to assemble an army of whitewalkers riding giants and take shit over already.
Edit: I was more down about the wolf dying than anything.
They dropped the ball on Robb. I bet most viewers forgot there was a war raging between Robb and Tywin because they hardly ever referred to it this season. In the book the slaying of The Young Wolf was a much bigger event. It started off so good with the King in the North-scene, but Robb fell off.