Thank you for the very thoughtful comment!
The way I headcanon it myself is that what the Queen and the Hero did get to have was a fully realised relationship, weird as it was and not meant to last. They saw each other for who they truly were and were irrevocably changed by their time together--for the better, one could argue (when death is viewed metaphorically). Not exactly a classical happy ending, or even one that shouldn't be mourned, but not entirely unkind either.