Are you asking because you are in a position to administrate a Linux system, or are you in charge of a Linux rollout, or are you just a developer that will have to use Linux in implementing an application?
This question entirely depends on what role you have in using Linux. Should you be afraid of it? Well...you're asking on Serverfault. I don't think too many people here will tell you that it's all that horribly "scary" to learn.
I'd say you should learn enough to know how to use it simply because if you're using an application that makes heavy use of that OS, you should probably be familiar with using it so you can troubleshoot and help others use your product.
If you don't have any reason or desire to learn it, I'd say don't use it. It's not the kind of thing you take up on a whim, and system administration is something that if you screw it up you become a poor neighbour to others on the webbertubes (spam relay, anyone?)
Install Virtualbox, pick a distro that is generally user-friendly but useful (like Ubuntu, maybe) and start experimenting with getting it set up as a workstation. Better yet get an inexpensive testbed and dedicate it just to running Ubuntu. Start using it for everyday tasks like email and web browsing. Set it up to run your application. If you use VMware/Virtualbox, you can take snapshots and roll it back and try again and reconfigure it to see if you can keep it running properly.
This was a long-winded way of saying that I don't know why you'd be afraid of trying Linux. Slap it in a virtual machine and see what you can do with it. If you're going to be able to support the application you're working on, you almost have to know some of the paradigms Linux uses compared to, say, Windows. Plus if you ever use OS X, the BSD underpinnings are very similar to Linux and you have a leg up in learning the ropes compared to people who never leave the Windows camp. You may even find that some things are nicer to work with under Linux than Windows, as long as you're not married to a particular application.