Former Gaelic footballer Charlie Smyth says he is "soaking it all in" after his game-winning field goal for the NFL's New Orleans Saints.