Mariah Carey's late sister Alison hoped for a deathbed reconciliation after years of estrangement