Yeah definitely feels like it's missing a proper ending.
Well, HoloEn3 has just been released last month, maybe someday when more of their lore gets revealed they can be part of the song someday?
Edit. Found out that HoloEn3's story is abit separated from Myth and Council/Promise, but on the good news, we also got HoloEN4 (Justice) so at least it can roundabout back with Advent, even though Advent and Justice's feud is smaller compared to what Ame's been doing to save her friends..