This is indeed a big issue, of how Western secularism splits roughly into optimistic, uplifting mainstream culture and more pessimistic, subversive countercultures (ecological, existentialist, cosmicist, nihilist, etc).

I've written a lot about this intriguing divide. Here are some related articles:

https://medium.com/interfaith-now/are-atheists-overconfident-in-reason-e589eccb1cd8?sk=f23d1cf246325465bf331b55a5a5903d

https://medium.com/@benjamincain8/scientism-and-the-downfall-of-new-atheism-919213775919?source=friends_link&sk=c498c50bbf9c48358087e8163fa6d27f

https://medium.com/grim-tidings/the-kernel-of-truth-in-neil-degrasse-tysons-juvenile-scientism-6d327b6f15cc?sk=53a4192c463f64144c0bb4f016f8f3c1

https://medium.com/grim-tidings/how-philosophy-gives-a-cosmic-perspective-in-gods-absence-c10c34b73321?sk=c4634e8ff003388cb35208707e16048a