Do fairy tales have to have a happy ending?

No, it does not. But it is the traditional way of ending a fairy tale. Non-fairy tale books may also end with "The End". It is not required in any way, it is just a fun little way of ending a story.