It implies someone is excessively proud of themselves and thinks they are superior to others. This often leads to them being dismissive, condescending, and disrespectful.
While there are rare instances where arrogance might be perceived as a positive, such as in a strong leader who needs to project confidence, it's generally not considered a desirable trait.