Read a sci-fi anthology sometime in the 1980s, though the story feels like it's from the 50s or 60s. An all-male starship crew is trying to return to Earth after performing some mission, but they're lost and for [reasons] are reduced to wandering from system to system.
The crew is in suspended animation between systems, and when they arrive at a destination, the crew is revived and a two-man scouting party is sent to the planet to check if it's Earth.
They've been lost for some time, and the crew is succumbing to despair. They lose men to suicide each time they come up empty.
After arriving at the latest system, the captain and a crewman go to check out the planet. On it are the
radioactive ruins of a civilization (may not have been due to a nuclear war), which shockingly turns out to be
Additional detail (that I may be pulling from another story, but here goes: in the location where they make the shocking discovery, the room is filled with a thick (like centuries or millennia worth) layer of dust). The crewman laughs wildly then shoots himself in the head, the captain returns to the ship, sets the navigation controls to the next system, and records a message to the crew for the next wakeup along the lines of "buck up, lads, the next one might be home."