Rosetta mainly does translation, but it does emulation for code produced at runtime.
And why won't it let me load a dylib compiled for ARM into an x86 process?
Well, it would have to keep track of which regions of memory are code it has translated and which are data that was written out by the program it's executing.
It can check if a branch or jump instruction goes to data, and then jump to its emulator instead.