Did MS Dhoni's 110m Six Cost CSK The Game Vs RCB And Playoffs Spot In IPL 2024?

Dhoni hit a 100m six off the first ball of last over as CSK required 17 to qualify but then runs became hard to come by. But why?