I'm obviously thick, but this is the first time it's dawned on me that the Claude names were types of written work. Now I'm wondering why Opus isn't the top model; isn't an opus a more impressive (or at least larger) piece of work than a fable?
An opus is just a musical composition, sometimes also used about written work, but it doesn't really imply a great work. Maybe you're thinking of "magnum opus"?
I don't have a cohesive explanation for each one, but in my mind a fable is basically a legend (or in other words, a myth/mythos) and a legend is the final form of a story. Even though it has been half forgotten and changed, it still lives on, affecting people across times greater than a human's short life.