Manchester Cathedral’s fundraising chief has defended the use of the building for raves ahead of another club night next month.