Adam had been dreaming of becoming a famous football player ever since he was a little boy