There's still much talk of a couple of Typhoon squadrons being based there eventually, including 6 Squadron which may still become the Saudi training unit. As for the Reds, I wouldn't be surprised if they also move there. I asked RAFAT people about this last year and they said that all the gossip about Leeming being unsuitable just wasn't true, and they could transit back to Scampton to practice, etc.
Now that Sir Glenn has told the press that he hopes or expects the Reds to stay somewhere in Lincolnshire I guess it must be almost certain that they'll move to Yorkshire...