Of course the can be used only as module. They are closed source binary drivers and will therefore NEVER make their way into the kernel.
I don't understand why nvidia isn't releasing the nforce drivers under the GPL. It's ok for the graphic divers, but just for a network ? There's more hassle than gain in it. For example those drivers won't run in the beta kernel series.