The moment 94-year-old Roy, who's living with dementia, fulfilled a lifelong dream by scoring a penalty