The main function of the kidney in the excretory system is to filter waste products and excess substances from the blood, producing urine. This vital organ helps maintain homeostasis by regulating fluid balance, electrolyte levels, and pH. It also plays a role in blood pressure regulation and the production of hormones.