Avoidant friendship collapsing my faith

I've been a Christian for most of my life, probably 30 years give or take.

In the last few, I made a friend who I felt really got me, which is vanishingly rare. Then they went through a huge personal trauma and I resolved to be as supportive as I could, fearing for their life if our busier mutual friends at church allowed them to fall through the cracks. I was on hand whenever, made contact - or tried to - even when my social anxiety was screaming that I was being too much.

As they moved out of the acute phase of their trauma, they gently distanced themselves from me; I had jndeed been too much. Since then, it's got to the point where I was pretty certain they'd just blocked me altogether, and I accordingly stopped trying to contact them. I took the hint.

It gave me a new perspective on prayer and faith more generally. Why do I never hear back when I pray? In the human equivalent of my story, I understood silence as the absence of a wish to communicate, perhaps even the end of the friendship. What is there in God's (lack of) contribution to my spiritual life that suggests he has any interest in a relationship with me? Is it not more likely then that I'm attempting a relationship with a void, a concept, someone else's idea of the supernatural, some ancient people's national deity?

It's feeling more reasonable and less traumatic to conclude that no-one is listening than that he hears and chooses not to respond. I'm aware the pain I feel of losing a friend is being projected onto the divine, but what else can I do?