Hi Lance,
I went through a similar epiphany of thought. Actually, I got so intrigued with the story of the earth and life on it that when I went back to school did my undergraduate degree in geology. Then went on to the masters... just graduated with a geology M.S. in Decemeber.
One of the recurring lessons of geology and paleontology is that no species is special. Humans have a tendency to think we are special, but we are not. Species appear and disappear in the geologic record. Some persist for a long time, while others are a "flash-in-the-pan." Some species develop, evolve, radiate and exploit all of the genetic potential they have. Others find their niches and there they remain for hundreds of millions of years.
I have my doubts about the long term prospects for humans, but that doesn't diminish my fascination with the "ultimate story" that the study of geology offers.
You are definitely on the right track by embracing the truth of what science has revealed to us.
All the best and ROCK ON!
Alex