Pride event in 'conservative area' of Norfolk scrapped over lack of support