Node.js in the cloud
A fairly large portion of in-house apps operate under the "small scale" scenario Payne describes above. Thus, for most organization, Node.js can, and should, find a place among your tools of choice.
However, it's important to note that, outside of .Net, most modern enterprise Web apps are Java-based. Dynamic scripting languages haven't crossed the mainstream enterprise chasm to any significant degree.
It's certainly possible that Node.js, like other dynamic scripting languages before it, won't play a major role in your data center, but it could still affect your IT operations, as many cloud service providers are eyeing its use. They are starting to see Node.js as an appropriate technology for Web apps that need the elastic scale characteristics a cloud provides.
Joyent, a startup that employs Node.js creator Ryan Dahl, and Heroku, a cloud service provider, both offer Node.js runtime environments in the cloud. And it wouldn't be surprising to find Google supporting Node.js on Google App Engine someday soon, a move that may be accelerated depending on Google's future strategy for the Java ecosystem.
Either way, by allowing less experienced developers to contribute more deeply to your IT portfolio, Node.js could be well worth the look.