In deed yesterday wasn't one of your best days . As you guess there is no way to remove the stain, but there is always alternative. The stain can be hidden by rubbing around it with steel wool. This will lift the carpet fibers and cover the mark. Next, pour into the burn hole a small amount of clear, waterproof adhesive and using a pair of fine pointed tweezers, pluck fragments of pile from the surrounding carpet and push them into the adhesive. When dry, tease the patch with a small wire brush to remove any glazing effect. hope this will help.