Unfortunately I don't have a good, compelling way to explain why I think constraint programming is so important. Here are a few attempts.
Constraint programming transforms a program that determines whether a possible solution is acceptable into a program to compute an acceptable solution.
Constraint programming allows you to write the specification of your program and then separately search for ways to fulfill that specification, either manually (by specifying search strategies/proof tactics) or automatically.
Constraint programming allows you to abstract away the question of which values in a subroutine are returned and which are provided as parameters. If you have only two such candidates, like the tired old °F↔°C example, this is a minor saving. If you have many parameters, it can be a major saving.
---
So much for why constraint programming would be important if we could do it. Now what's new about being able to do it, particularly since 2006?
I'm not a specialist in the area, so this may not be the best possible answer to the question.
However, it looks to me like miniKANREN is one important development: it's a logic programming language far more powerful than Prolog. cKanren is an extension to CLP.
Also, SMT solvers ("SAT modulo theories"), which are capable of fairly general-purpose constraint solving, have gotten enormously more efficient since 2006. One of the fun things about exponential-time algorithms is that reducing the base of the exponentiation even by a little bit can produce enormous speedups in practice.
Additionally, constraint solving shades over into optimization. In constraint solving, you have a bunch of absolute constraints, and you try to find a configuration that satisfies all of them. A configuration that barely fails to satisfy any of the constraints is no good. (Although this book talks a bit about "soft constraints", too.) In optimization, you have a "loss function" that you try to minimize (or equivalently a value function you try to maximize) and so you're looking for a configuration with a good value of this function. So if you turn each constraint into a Boolean variable that takes on 0 or 1 and subtract their product from 1, then you've turned a constraint problem into an optimization problem. (Maybe you want to sigmoid out the 0/1 transition a bit in order to keep everything differentiable.) All this stuff we've been seeing about "deep learning" and "machine learning"? Those are optimization problems! You can use those techniques to solve constraint programming problems, and you can use CLP techniques to dramatically speed up optimization problems. This is in its infancy. A really cool example of solving inverse kinematics constraints with optimization (just using gradient descent and reverse-mode automatic differentiation) is http://www.mattkeeter.com/projects/constraints.
Finally, lots of the things we run on our computers — word processing, spreadsheets, HTML rendering, TCP/IP — really don't benefit from the immense increases in computation and memory that have happened since 2006. But constraint solving is NP-hard, and consequently it can eat up all the computrons and DIMMs you can throw at it.