The pop legend discussed his own battle with a brain tumour while presenting an award to a brain cancer survivor