The code was imported to FreeBSD-current on the 16th as seen in the commit mail, so I suppose it will be part of the next major version (7.0). I have to thank Rohit Jalan, Howard Su and Glen Leeder for their efforts in this area.
Some more details are given in their TMPFS wiki page.
Edit (June 23): Mentioned where tmpfs is being ported from!