It's not about Facebook clone, they still use MySQL for some functionality (i believe), but not as RDBMS but more like NoSQL...
NoSQL means model your data in a different way, the way you'll be using it. For some it makes more sense, for some may not.
For example, compare implementation of a tagging system in mongo and any other RDBMS, which one is easier?
Maybe when developers don't want to bother to learn SQL?
On my CS degree we got proper introduction to SQL and the relational algebra behind it, so for me it is just a tool, not a scary monster.
I really love the data integrity options I have at my disposal with relational databases.
So for me this all NoSQL fad never made much sense. Then again, I never had to deal with a Facebook like scale problem, only daily reports from mobile network operators across their whole network elements.