I think it's a pretty good match. Since you both have Capricorn rising, this puts the same sign on the cusps of all 12 astrology houses. This means you have similar ideas or attitudes about the important matters in life, always helpful in a relationship, especially if you are considering a long-term one.
Your Pisces Sun means you are sympathetic and creative, and his Cancer Moon means his emotional makeup is sensitive and nurturing, so I like this. You both have creative and artistic talents, and both need time to yourselves, so will understand that about each other. His Leo sun means he likes to shine, and is most likely very sociable and popular. You are a little less sociable being Pisces, so will want to go out less than he does.
Also, Leo men like women with a lot of bling, although Pisces women are sexy and have a mysterious aura that he likes. You are critical with the Virgo Moon, but also practical and serious, and he respects this with his Cancer Moon. Try not to nitpick about little things too much. Also, you both come off as more reserved than you are with the Capricorn rising, so that tones down his Leo sun a little bit. That's the only part that concerns me, because Leo wants all the attention and likes to be catered to. But his moon and rising sign tone that Leo down, so I think you will be fine. Best of luck to you!