I don't think you have to load that module, you just have to edit the file
/etc/X11/XF86Config and under the Section for your video card where the old driver would be
nv and change this to
nvidia. Also make sure to comment out
load dri
If you want some different modules installed on startup you place the command
modprobe name-of-module in the file
/etc/rc.d/rc.local
HTH