For a short explanation, this is an in-game death where the protagonist do stop the infection but had to sacrifice itself in order to. Now, those Siblings will come to rest, remembering their once-alive savior of Hallownest...

(Silksong when-)