A Newcastle United fan recently given six months to live has described watching his team win the Carabao Cup as “the pinnacle”.