The main purpose of the flow designer in Design Center is to design and develop fully functional Mule applications in a hosted development environment. This tool allows users to create integration applications by configuring connectors, building logic, and managing data transformation processes within a graphical interface. It provides a user-friendly environment for users to build and deploy Mule applications efficiently.