It can be; swap and suspend-to-disk / hibernation can cause tmpfs to be written.

I wonder if there's a way to execute from mlock'd or madvised memory. I can imagine this be particularly useful, if you wanted to prevent your injected program (malware? valuable IP?) from being written to disk or appearing in a core dump.