After dreaming of playing in the NFL, Charlie Smyth says making his debut for the New Orleans Saints was "the moment I've been waiting for".