No lesser light than King Solomon pondered not just that question, but furthermore punctured the arrogance of those who presume their own spirits to go upward while the spirit of the beast only goes down into the ground, in the Bible. Ecclesiastes.
That’s as good explanation as any for the rhetorical “who knows that” question of Solomon. Solomon didn’t produce any prophetic writings to our knowledge, but he was a skilled theologian and compiler of wisdom sayings (proverbs). I am not familiar with Hebrew lore of that time about the animals.