If Refresh Cohort Days is triggered, would this wipe out any manually-added student-specific overrides on particular days?

Yes, unless a person cohort day record with an override value is locked, the data will be reset when the Refresh Cohort Days process is run.