Exactly. WD-40 is petroleum (oil) based, and the paint will fail. On top of that, WD-40 penetrates, and even if it seems dry it can still be active and ruin a paint job. I know pro painters that won't even let a can of it inside their shops.
No one lives forever, the trick is creating something that will.