Pete Waterman has said taking on the role of patron for Brain Tumour Research is “his life” after losing his son Paul to the disease in 2005.