I loved this idea (and it rang very true in context) in the Hadestown musical, which is a retelling of the story of Orpheus and Eurydice - and it begins with lyrics like "It's a sad song, it's a sad tale, it's a tragedy - but we sing it anyway".

Knowing how the story ends can sometimes even make it better, when it's a really great story.