Same reason people climb mountains, cuz they are there. I currently have Al, Ti, and carbon road bikes. Had a number of steel bikes in years passed. A lot depends on the specific design and implementation, but carbon can provide a combination of mechanical properties that the other materials can't, which is why it's becoming common in many other applications like aeronautics and aerospace.