The Magpies skipper led the emotional celebrations after his pre-match pledge came true