So if I've read everything correctly, Snow Leopard will full ZFS support but Apple haven't said whether it will be the default filing system or if there will be an option for it to be for home users?
Personally, I'd be surprised if either is the case and that at best it will be severely crippled for end users. The snapshot functionality (and all the related stuff) is great but would cause a lot of confusion for end users, for example the total drive capacity minus the size of all files on the drive does not equal the remaining free space.
The worst part is when you change a file that was created via snapshot - you will often see free disk space reduce but the size of allocated files stay the same. Try explaining that to an end user.
Using it for Time Machine drives makes a whole lot of sense, but it would raise the question of why Apple didn't use it for Time Machine drives in the first place rather than in effect, hacking their own version of it instead.