For normal users of FreeBSD, nothing has changed. You can still use csup/cvsup to update the ports tree and the source tree. You can still use
http://cvsweb.freebsd.org to browse the source tree and review commit logs. As far as using FreeBSD goes...it's still the status quo.
If you are a FreeBSD committer, then things change. Now, commits go directly into SVN, and an automated process copies the commit into the CVS tree.
So, unless you are developing software for FreeBSD, that will be committed into the FreeBSD source tree, and you already have (or will be getting one soon) a commit bit, then nothing has changed.