Hi OP-
I am a Pitt grad. Pitt is a great school for an eclectic courseload. It's not known for studio arts but it has them, and you can cross-register with CMU.
Here is some info on Pitt's geology department:
https://www.geology.pitt.edu/prospective-students
The history department at Pitt had a wide variety of courses when I attended, and I expect it would be a pretty large department compared to geology. I enjoyed medieval studies series guest lectures and went to a 2-day conference on medieval Spain while I was enrolled. Also took 2 art history classes in the Art History department. Even though I was an Economics major.
The Carnegie Museum of Arts is right there in Oakland between the two campuses. Also Pitt has a very nice fine arts building right across the street from it (imitation Renaissance villa). That's where a lot of the art-related classes are taught.
Non-university students/everyday artist learners take classes at Pittsburgh Center for the Arts in Shadyside. That's probably reachable by bus from Pitt.
I am not sure if there is the right nerdy vibe at Pitt in the exact majors you are researching...but honestly I never understood why CMU would appeal to a liberal arts generalist or maybe someone with a couple strong liberal arts areas of interest. To me CMU was always more suited for students with a very specific career plan, and mainly quant-oriented majors. Some artsy majors like theater and architecture also come to mind. But not history. I doubt a CMU history degree's better than a Pitt history degree if the GPA is equivalently high. Especially if it costs a lot more to acquire.