The simple answer: no a woman shouldn't lead the relationship. This lack of confidence he has is why women keep leaving him.
As to end the relationship, I don't understand why this will ruin the friendship. Is it just that misery enjoys company and he wants you to go through similar experiences? He is just being emotional. I am learning emotions should just be patiently waited through until reason has restored itself.