Why do myths often have sad endings?

Ancient Near Eastern myths often appear to conclude with the banishment or crucifixion of the hero, but this is not always the case. The Flood story in the Epic of Gilgamesh and the biblical story of Noah has an essentially happy ending. The thing with myths is that they try to teach us something. Sometimes this is achieved with a sad ending and sometimes a happy ending.