MSI is created for IT departments to roll out the app across corporate networks for mass deployment. MSI doesn't support auto-updates by design. This allows IT to control the app version installed on corporate machines. The app files are installed into the Program Files directory and accessible for all users on the machine.
MSI is intended to be deployed via deployment tools like Microsoft Active Directory GPO, Microsoft SCCM, and Microsoft Intune. It requires admin permissions for installation.
EXE installer is for per user installation. It doesn’t require admin permissions to install, supports auto-updates, and is accessible only for the user who installed EXE. The app files are installed into the user profile directory. EXE doesn't work correctly with deployment tools like Microsoft Active Directory GPO, Microsoft SCCM, and Microsoft Intune because they are running EXE on behalf of System users with elevated permissions by default. EXE doesn't support this mode of installation.