The password was changing everyday where I worked, with the daily password available on an intranet page, but then a few months ago a bunch of higher-ups were present in the office for a few days and wanted Wi-Fi access without having to type a new password each day, so the password rotation has been deactivated since

Well they chose convenience over security, which in this case is fair enough (it's public Wi-Fi to being with).

Another solution would've been to implement WPA2 Enterprise, where employees could have their own, permanent credentials while visitors get temporary ones.

Also I don't think you can access anything in the intranet on that Wi-Fi, it's entirely public, as you said.