The visible light era of the Universe is relatively short compared to what comes after. People think of this as a long dark night. To some extent that's true.

Another perspective is that this will be the Golden Age of the Universe [1].

[1]: https://www.youtube.com/watch?v=Qam5BkXIEhQ

I do understand what you mean. I have a personal philosophy that deals directly with existential dread. I may not explain it well here, but I'll give it a go: In the face of the yawning void both physical and metaphysical, we humans have the preternatural ability to construct meaning where none exists. We are smaller than mites, floating on dust, vulnerable and doomed; and yet, here we are, defying that nothingness; writing, loving, making things against odds so unlikely we have a difficult time comprehending it. We have the nearly divine ability to pick something arbitrarily and declaring "This matters. This is important, because I say it is." and therefore it really is important and meaningful. Until we decide it's not. This ability to construct meaning is extremely powerful, and will serve us as we march into the trillionth eon at the end of time.