The Weyl double copy from twistor space