my advice is simple. If you dont want to do an engineering degree, then dont. If you're not 100% sure about doing a course anyway, and want to be a pilot - I'd recommend not going to uni at all. I know thats a shocking thing to say, but after 2 years at leeds and a year of aero eng at manchester, I feel like I'd love to leave now and get a job. I would if it wasnt for the debt of 12000 and getting nothing for it.
At 21, I could have had my flying instructors licence and CPL and be on my way to the sort of 500 hour mark. As it stands I feel like I'm wasting my time at uni.
The Leeds degree is getting better - modules becoming more relevant. So I recommend Leeds over anywhere else - definitely dont do an aero eng degree if your not sure.
A final point - if you're doing the course just for the PPL on the cheap (like about 50% of our year are), then dont do it.