This seems to have an obvious counterexample?

The name of the Streisand effect is from exactly the situation of a photo nobody cared about of Streisand's house from decades ago. The fact that it can be superficially referenced is evidence of its longevity.

Not sure. Hardly anyone would remember if Streisand was a singer or actor or whoever. Now her name is mostly tied to Streisand effect, not the art she had produced.

I agree with your point of view. Maybe it was effective when it was the first effect. Like the million pixel website. Now there are million balls in the air. There are lot of current things going on. People will move on when they get tired. And the only memory they will have is "something happened".