I don't see a pilot studies option for Leeds but I know there's one for Sheffield where you take all the theory and get 10 hours of flight for £1000 which is a fantastic deal.
In terms of the courses, Sheffield gets right into aerospace from the get go whereas Leeds doesn't start until year 3 and is very focused on mechanical engineering until then whereas Sheffield's course is quite broad and gives you options to specialise in different areas of aerospace from year 2. Sheffield also has the better reputation and lower grade requirements.
As a word of advice, if you want to become a commercial pilot, don't do an aerospace degree, go and join the RAF instead, it is by far the better way to get into the career as going via a degree or other pilot training schools will likely get you into a bunch of debt. Also at the start of my degree quite a few people I knew wanted to become a pilot or at least considered it an option, halfway through the first semester I can think of no one who still wants to.