You can still be fired for cause. The intent of tenure is to protect academics from backlash when they choose to research politically unpopular topics or say politically unpopular things, not to let people get away with being abusive or sexually harassing others or committing gross academic misconduct.