Getting ghosted after a second interview happens to almost everyone. It says more about their process than your future.

Organisations go quiet for internal reasons: the role got frozen, somebody left, a manager cannot decide, nobody was given the job of telling you. None of that is a message about your ability, though silence invites you to read it as one. The second interview means you were genuinely in it. What happened afterwards was theirs, not yours.

Allow one short follow-up and then move the whole thing into the past. Keep the practice you got, because a second interview is a skill you now have more of than you did last month. Apply somewhere else this week rather than waiting on this one.