“This is the law of the Torah that Adonai has commanded….” (Number 19:2)
We expect a true revelation to follow such an introduction, The Law of The Torah should be the highlight of the most sacred book of all, the Law coming from Adonai our God should be a moral uplifting moment of sacredness.
And the Law of the Torah is about the red Heifer. Something that makes no sense, something that Rashi the great commentary to the Torah is afraid that will cause ridicule.
Not everything in the Torah actually makes sense, a big chunk of the Torah makes no sense, and there is no point in trying to find logic in it.