Well, I was about 8 years old, so it was just ... neat I guess. In a creepy movie kind of way. I remember it being very yellowish but maybe that was the color of the lights.
Also I've never been in a mine since then.
It was a common "field" trip for kids in the Detroit area. I went as well, and yeah, there was something very pleasant about the trip. I imagine it was notable for the fact you didn't get a ton of field trips, much less to one with giant machinery down a rickety elevator with an element of danger.