MediEvil 2 chalice bug?

In MediEvil 2 (ps5 version) I think my chalice rewards broke. I got everything as normal for chalices 1-6 but for 7th chalice (after beating The Count) I didn't get Lightning, I just got Gold.

Is my save ruined now? I need to restart game completely if I want 100%?

But how can I prevent this happening again?