Interactive version: https://back-on-track.eu/night-train-map/
The problem is that for most people over about 21, the biggest component of “comfort” is privacy. This is why people book hotels rather than hostels, even when the hostels are stylish and luxurious. Of course, night trains can be hotels-on-wheels too. The better ones have first-class cabins with private bathrooms. But this makes no sense from an environmental point of view. At this point you might as well take the short flight.
The best couchette-style service in Europe right now is the recently introduced Nightjet mini-cabins. Capsules, basically. This is a major step forward IMO but I still don’t see this tempting most normie travelers. And so expensive, too.
Once they start rolling out more mini cabins I hope it will become more affordable. I think this can be the future to expand sleeper trains to a wider audience