I saw a couple of tinfoil theories in here, so I thought I'd throw my own interpretation in, and the lyrics I got.
The song of the shifting sea, the kiss of the a salt sweet breeze;
The warmth of her silken dress, stained in red.
Her memory fading fast, her mother sits eyes downcast;
A tormented form in hand, farewells unsaid.
Not once a certainty, lost in grief;
A daughter's desperate cries, unheard pleas;
Forsaken ancient rite, on her knees:
A prayer passes from her lips, into her soul the goddess whispers:
"A heartbeat without harmony is rhythm without time.
The heart seeketh equilibrium: with balance fill your world with calm.
So sing this broken melody and let wings shelter thee.
One must stay by leaving; an empty heart the light will see."
TINFOIL TIME
I think that the daughter was pregnant, things went wrong while giving birth, and after she delivered, she died. The mother, meanwhile, was unable to deal with losing her daughter, and so she ignores the newborn daughter and tries to bring her daughter back to life, praying that it will work.
I don't think Sophia actually offered to grant anything: it sounds more like she told the mother instead to offer herself as a physical vessel for Sophia--like Ysayle did with Shiva--and that was ease her pain.
Now if that's right... what happened to the child?