I went through customers section in the notifications and sent emails to my test emails and they are from the correct sender email that is shown in the settings → notifications → Sender email.
It is still puzzling why the spf report records show fail, but the spf in the actual email shows success.