CAP theorem has really served to pry up a lot of things we thought were just about nailed down. I think it’s comparable to what Einstein did to Newton: just a minor change in the way we look at things that compacted all previous ideas into a trivial case for a far weirder world.
For decades, the world of databases was synonymous with relations, transactions, and SQL. Finally it has exploded into exciting, CAP-driven diversity. Key-value stores, string stores, object stores, and well — my favorite — graph stores are suddenly just about everywhere, and each projects is playing by its own set of rules.