How does the Almighty's saying: "on a Day when no parent will atone for their child" align with the reward for honoring one's parents on the Day of Resurrection?

The verse: "O mankind, fear your Lord and fear a Day when no father will avail his son, nor will any son avail his father at all," negates that anyone bears the burden of another's sins, and it has no relation to intercession, which is established for believers on the Day of Judgment, as they will intercede for one another. And Allah may, out of His generosity, elevate believing offspring to the ranks of their parents in Paradise, as stated in His saying: "And those who believed and whose descendants followed them in faith – We will join them with their descendants, and We will not deprive them of anything of their deeds. Every person, for what he earned, is in pledge."