A mission that promised dramatic fireworks as two spacecraft smashed into the Moon at more than 5,000mph ended up looking like a damp squib today.