"the module failed to load"
Umm... what did you do? Anything in dmesg? I fail to see why it would load manually, yet not when the alias is there... Is there a line in /etc/devfsd.conf looking like LOOKUP .* AUTOLOAD? With the new alias, does modprobe /dev/nvidia0 work?