I'm fairly sure there isn't any 'very rare fauna' anywhere near WCJ. There may be some fairly rare flora and habitat types, though these will be on the cliff-tops and above meaning they and sport climbing can co-exist fairly well.
The DWT already own much of cheedale so any climbing related issues will no be new to them; they seem to be a pretty good landowner.