What’s Wrong With NoSQL?

Is it worth using the term NoSQL? How correct is it to use it and are there times when it is really needed? What is behind this term and why is it still used today? Let's try to answer these questions - and not only within the framework of the discussion.