Spoiler Kind of. She remembered that she is God/Heaven's Will, so "Sang Sang" personality disappeared. After that she killed Ning Que's teacher. His body became the Moon (sound familiar... I'm pretty sure I don't talk about Naruto) Don't sure this is tragedy or not, but Ning Que successfully deflowered and impregnated her before all of above happened.
Its a tragedy cause many likeable characters die for example, the Emperor and Empress. The process that Ning Que goes through to manage to convince Sang Sang to love him is also quite tragic.
In what way? No im curious and with the current translation, i know it's a long way so im interested in spoiler. In fact im currently at the part where she became disciple of the divine guy, was she forced to go against the ning que? Though i doubt it would come to that
Nah, its because Sang Sang is Haotian. Later on, she regains her Haotian persona and tries to forget Ning Que.