The Age of Fracture ending is the one that Melina wanted throughout the game. She's sacrificed herself as kindling to burn down the Erdtree, and fulfilled her goal of seating the protagonist on the Elden Throne. This is presumably a “good” ending, and a semblance of order should be restored to the Lands Between.