That's a tough situation to deal with.
It's often that part of our attraction is based on the feeling that we can help the other to grow and flourish. Failure in that effort is a guilt trap.
The reality is that it is very hard to change people and/or their situation. Don't feel guilty for failing an impossible task- feel good for having tried and done what you could.
You have my sympathies, too.