I can hardly believe that there are so many of us in this situation.
I think the request to be friends is hurtful because there is no space made for our hurt, sadness, grief, anger, confusion, and loss. The coming out spouse often doesn't want to hear it. Society doesn't want to hear it either. I didn't invest decades of my life with someone just to end up as friends.
I wish all of us healing. This is nothing I would wish on anyone.