That’s how “active” works afaik. “Active” looks at latest comment, so if it’s an old post, it will still go to the top because there are recent comments.
You can read more about it here: https://join-lemmy.org/docs/en/users/03-votes-and-ranking.html