[...] For instance, virtualizing Mac OS X Server 10.6 (Snow Leopard, which has Roseta 1) in VMware Fusion inside virtualized macOS 11 (which has Roseta 2) in future Apple Silicon Macs. Is that technically possible?
But, as dempson said: [...] Rosetta 2 has nothing to do with this: it provides code translation to run Intel processes on an Apple Silicon Mac under the host macOS. It does not provide a way to run an entire Intel operating system in a virtual machine, and cannot be used to assist virtual machine software to run Intel code inside a virtual machine. [...]
So, basically, you cannot run a virtualized Intel Mac OS X 10.6 VM inside a virtualized (with a future Fusion for M1) ARM macOS 11 VM: this would require x64 emulation, as Rosetta 2 cannot run an entire Intel VM; i.e., an Intel macOS 11 guest (which could then run a nested Intel Mac OS X 10.6 guest) on an ARM macOS 11 host: but with x64 emulation you could of course also run an Intel Mac OS X 10.6 VM directly, with much better performance than a nested one.
A little complicated reasoning (I hope it makes sense), so correct me if I'm wrong...