The six-time Olympic gold medallist was diagnosed with terminal prostate cancer in 2024 and was told he had between two and four years left to live