The family of Cherry Valentine — who was born George Ward — announced the drag performer "tragically passed away" in September
