The main differences can be summed up as:
-Cut duration
-Cut quality
-Materials to be processed
-Sharpening
-Price

Read our detailed report Diamond and tungsten carbide tools: what are the differences?