A recurring theme in eg HP Lovecraft is that understanding the infinite universe drives a person mad. But recognizing you are a small and ultimately unimportant speck is only horrifying if you live thought that you're a central player in it.
"A Better Place" by clipping is a happy ending, not a ln awful one. They talk about this in an interview I can't find.