Queens is indeed affiliated with Manchester And Salford Universities Air Squadron. That will still be the case. Obviously, they don't expect anyone from there to attend the ground training nights every week, nor be available for the regular AT or flying activities, it would mean you miss out on a lot. But you would still get the annual camps and the Summer Vacational Attachments assuming you maintained regular contact with the staff.
UAS is applicable to all RAF branches and is massively less pilot-orientated than it used to be, or was even 2 years ago. But again, you'd get questionable use out of the system.
There are no specific degrees covered, unless you were going for a medical cadetship or engineering, I know of pilots to be sponsored with degrees from Aerospace Engineering to Physics to Geography to Portuguese.