How do I set Live Activities to Light Mode?

You can't. As of iOS 17, Apple makes Live Activities appear in Dark Mode by default, regardless of your device settings.