I know the comparison between Air's tunnel and Pirate Advenuture is probably a bit tongue in cheek. But without wanting to kill the joke, they are different situations. The cost of theming Air's tunnel would be tiny compared to the cost of bringing back Pirate Adventure. Galactica was a golden opportunity to sort the theming out, but instead they went for a short lived VR system. Even if people liked the VR, the fact it was so short lived does imply that theming would have been a more permanent and better use of the money. The Looping Group might not be prioritising Pirate Adventure, but Splash Canyon, Adventure Cove and the new viking area (if that's what it is), may well be a sensible use of the money.
The Buffalo gets a lot of criticism, but so do most family coasters. If you look at most enthusiast's top coasters they're all fairly intense. I like powered coasters, and the fact it goes out over the lake is a bonus. If they do a good job with the re-theme it will be a decent family coaster. I'm not a massive fan of disco coasters, but it will be the park's biggest genuinely new ride in a long time. The park had somewhat moved away from immersive themed areas (aside from Thomas Land), with Action Park losing its Wild West elements. Another clearly defined area will be a good thing for the park.
Apocalypse will be a big loss (and I liked Pandemonium), but things are definitely exciting at Drayton Manor.