The notion of a dream job is rather silly. Historically very few people in prior generations ever had an opportunity to work in a dream job. They took a job they could find and got on with it instead of whining.

Today there are many other employers hiring rocket engineers. Try Boeing, Northrop Grumman, or RTX. A lot of experienced engineers are retiring so there are opportunities available. But you can't be picky about location.