Well I would say shame is, and being ashamed of oneself is as useless and harmful as self pity. Don’t wallow in feeling ashamed, which traps one in a vicious negative feed back loop of avoidant behaviors like substance abuse. Rather, learn from the mistake and take steps to improve oneself.