I did BEng Aerospace Systems Engineering at Coventry.
Basically what the systems are what they do and how to design them. Everthing from the most complex of topics like data bus systems and aerodynamics, to air conditioning systems.
Was 22 UCAS pts last time I looked.
Would also recommend looking at Southampton. Thats where the forces send their aero engineering cadets.
As for relavance to becoming a pilot, the knowledge you gain will help you with technical subjects in the ATPL's. It also shows dedication to the aviation industry. Also, if it all goes wrong a very attractive career in engineering will be there to fall back on.