Who Is Leonard Cohen's Song 'Hallelujah'

The very first verse of “Hallelujah”, written by Leonard Cohen, pains me because it brings me back to the feeling of doing everything in my being to please someone close to me, yet it still not being enough to make them happy. On the other hand I see it as Cohen talking about how his faith in God is so meaningful to him, but someone in his life doesn’t share the same faith. While reading the lyrics I cannot help but to think about all the biblical references. Having those references disassociates me from the song a little bit since I do not understand the majority of them. However when I hear the song I do not think much about the words, but rather the soul and beauty attached to those words.
The whole song speaks of unrequited love yet when