After digging a ton, the issue was caused by the workspace setting "editor.formatOnSaveMode": "modificationsIfAvailable". Removing this allowed me to configure the formatter for HTML as Prettier in the workspace without needing to set any User settings.

Not sure why format on save still worked with the same configuration but a different formatter, but at least it works now.