Keep in mind that Pillars of Creation is not supposed to be intentionally beautiful. It's a false color image for maximizing research value. Green for hydrogen band, red for sulfur band, blue for oxygen band. The goal of the processing is to minimize the error in these three readings, to study the ionized gas in the cloud as it truly is. If it were engineered for the public to look in awe, you could probably come up with an even more striking coloring than a simple RGB assignment. This is something a lot of people get wrong about the topic of false color images -- usually, there is not a separate "for the public" and "for researchers" image. The media outlets just pulled the coolest looking processed images out of actual research papers, and some of them were so cool looking they became cultural icons. (The exceptions to this, ironically, are when an image is intentionally processed to be as close to true color as possible -- which makes it less useful for research purposes, but fantastic for writing explainers for laymen on the topic of false color images.)
Though, you could say it's indirectly designed for beauty. When astronomers process an image, they are looking for interesting features to study. And once you've narrowed in on the most scientifically interesting way to process an image, the sorts of striking color contrasts that creates are inherently beautiful because they are unveiling the interesting parts & letting us see the unseen for the first time. And there is selection bias on what is interesting to look at. A violent explosion is both more aesthetically inspiring and teaches us more about how matter works than a picture of a random stairwell, and astronomers love their violent explosions.