It simply boils down to the fact that no one can see the future, so saying "everything will be fine in the end" is a lie. But I have used it to comfort someone many times. I will think twice about that from now on.