Sir Martin Sweeting said the UK's decision to leave the European Union affected work with the Galileo space programme "quite dramatically".