Water might not get the drugs out, depending on what you were smoking in it. I'd need to know that to recommend a proper solvent.
Have you tried vegetable oil to get the burnt polyester off? Might work. Or something like turpentine, though I'd try veggie oil first. Soaking might help. Make sure to clean whatever you use all off with soap & hot water before using/applying flame again.
Potentially you could just burn all the fabric that can't be cut off, but I wouldn't try that personally, even outside, due to nasty fumes. I would get a new pipe if the nonpolar solvents don't help.