Describing this as not easy is a bit of an understatement; there has been a lot of research into speculative threading and communication overhead between cores almost always kills it.
I also think software people still have a innate fear of "wasting" CPU/memory/disk which is hard to overcome.
Compare with other databases that put an inordinate amount of effort and tuning into coming up with the one true query plan per query.