Organisers said the decision to cancel the show was taken with "profound sadness" after "genuinely encouraging" public support.