The name "NoSQL" doesn't give much technical insight into the product, so why name it so?

Marketing, I'd say. It's a very buzz-y term.