Exploring the Eagle Nebula, home of the iconic Pillars of Creation made famous by the Hubble Space Telescope