The short answer is that it’s difficult. And aero is often at capacity making it even more challenging. If your son has a direct pathway to to his preferred major at another school, I think it’s a much safer bet to go there.
Here’s the info from Purdue:
Your son may want to reach out to engrinfo@purdue.edu to ask how many students successfully transferred into the major last year.