I wouldnt go quite so far as to say it's the most anticipated game of all time, but it's certainly got a very large number of people eagerly awaiting it. Myself included.
Here is the basic idea of what I know:
BioWare, developers of NeverWinter Nights recently cancelled their publishing contract with Interplay whom had published all of BioWare's numerous other prior D&D RPG's.
This doesnt come as a surprise really as BioWare fired off a lawsuit against Interplay about a month ago.
BioWare is continuing development of NWN and all other games that were planned, they've said that NWN is not being delayed and will still be released at the same time as originally scheduled.
I imagine BioWare will either pick up another publisher, or they'll self-publish the game themselves.
Either way, it's in no way "the end" of NWN as it's still going to be released.... it seems likely that this should have little impact at all on NWN.