Pop star best known for her role in the film musical devoted her later life to activism in support of cancer research