The phrase that comes out when someone proposes NoSQL is "we're not Google / Facebook."
Most applications don't need to run at "Google scale," thus they don't need the expense of relaxing ACID.
Of course, consider your use cases. There are good reasons to use NoSQL, and excellent reasons to use RDBMS. I use both professionally and appreciate the benefits of each.
As others have said, if you operate at a certain scale and can get away without complex joins and aggregations (which you should avoid anyway if you’re operating a high availability service), then NoSQL is a great option. It’s easier to scale out (often you just turn a knob) and its behavior is simpler and easier to predict.