The musician died after fighting two types of cancer since 2016