Anyone else who is sober can help you with weak moments, by calling them, admitting it as plainly and clearly as you are able, and letting go of it with Hashem's help so that you can get back to whatever the heck you were supposed to be doing before the stupidity.
I called my sponsor plenty of times during those weak and scary moments, but please do not lock yourself into one person. Honesty and freedom from lust is just too precious a thing to be dependent on one person for.