I had two aerospace jobs and they were by far the most interesting jobs I had in my career. It is true that you’ll likely not be designing airplanes, and that groups tend to focus on particular subsections of planes. Aerospace companies will have lots more CS people than aerospace engineers.