The Scots sporting legend's story highlights the importance of cancer awareness