Is it possible to point an SVN Externals directive at a CVS repository?
No, it is not possible.
SVN externals simply does an checkout or update on the repository path you give it. Which doesn't support CVS.
The only thing you should point at CVS is a gun.. or cvs2svn. Long live SVN!