Elon Musk told CNBC that the failure of his Falcon 9 rocket in June was "definitely a setback," saying it made it tough for NASA because it illustrated just how hard it was to deliver to the space station.