The beloved TV personality and pop star's death comes after she faced a long journey with secondary breast cancer