Strictly Come Dancing 2024 winner Chris McCausland has turned the “scary” prospect of losing your sight into a “hopeful” story, charities have said.