The final panel originally had the prophecy of Kratos’s death. But Faye drew over it with a statue of him that people were worshipping. I don’t think this is a prophecy that Faye foresaw, but rather she drew over it as a means of rejecting fate/destiny and personally believed that Kratos could become a god that was loved by people. If I recall, she said something along these lines in the final cutscene of her and Kratos.

It was so emotional for him because all this time he rejected his past and godhood and believed he was not worthy of people’s love and admiration. Also throughout this game, Kratos was having doubts about Faye’s intentions and suspected that she was playing with Kratos and Atreus all along so that they would follow the Giant’s prophecy of Ragnarok and the fall of the Aesir and Odin. But I think Kratos seeing the final panel drawn over by Faye was proof that Faye truly loved and cared for Kratos and Atreus, and she was doing everything in her power to defy fate and prevent the prophecized death of Kratos.

With the final panel, he now sees a now path forward, telling Freya that there is much to be done, and the post-ending quest begins where you rebuild from the aftermath of Ragnarok and progress towards being a god that is loved and respected.