No it's not an idiom.
If someone fools me or deceives me once then it's bad for them, they shouldn't have done that.
If I let them do it again. Then it's bad for me, I shouldn't have let them do it a second time.
Fool me once shame on you.
Fool me twice shame on me.
btw I
like Bush and think that clip is hysterical