How do I change it back to Automatic?
Do not change the service please. This is working as designed.
KB85374 - Host IPS 8.0 for Windows Patch 6: New Windows service and changes
PD25972 - Host Intrusion Prevention 8.0 Patch 6 Software for Windows Release Notes
McAfee Firewall Core Service startup type set to Manual
For this release, the Startup type for the McAfee Firewall Core Service is set to Manual. The service is no longer started automatically. For more information, see KnowledgeBase article KB85374.
I've read both of those articles but it still doesn't make sense. When I run the following it tells me mfefire is running but it's not as a Windows service.
C:\Program Files\Common Files\McAfee\SystemCore>mmsinfo.exe -query mfefire
Looking in the Windows Task Manager it shows mfefire.exe running too but what's the point of a service that shows as not running but it's really running? This is confusing.
The "Manual" and "Automatic" startup types relate to the Windows Service Control Manager; from reading the articles, I understand that the new McAfee Management Service is now responsible for starting the required McAfee services.
Having a Windows Service in Manual startup just means that Windows doesn't automatically start it during OS startup; compare that with the startup type of "Disabled" which would prevent the service running at all.