I believe there’s some DH trails on Sutton Bank?
If not there’s plenty of XC riding around the NYM’s, although like most north Yorkshire stuff it’s 40miles of fireroad and 800m of gnarr.
Look on the bright side, you’re within 90min of
Peak District
Lake district
North York Moors
Yorkshire Dales
And the seven stanes are a (long) daytrip or weekend, I used to drive up Friday night after a late dinner, get 6 hours kip in the car at GT car park, ride the black, have a lazy lunch over 2-3 hours in the town, ride the red in the afternoon, sleep a lot, then do the blue Sunday morning and Inners in the afternoon before driving back.
There are quite a few roadie clubs local too. So if there isn’t riding for the door, just get fit and do big days out somewhere else at the weekend.