If there are already a few flags on a question, people might be hesitant to answer it. Other than that, there aren't any consequences, like a point penalty. Flags are usually just used to alert moderators and editors that a question might break the rules.
Read this answer for additional information.