Type D spacetimes and the Weyl double copy