I would say the main reason for Lucknow Super Giants' defeat is the poor performance of their bowlers. Batting for a target of 228 runs is much more difficult to win. Although the pitch was batting friendly, scoring 128 runs off 120 balls was a tough task. Even so, de Kock and Kyle Marse managed to get off to a good start. Had the other batsmen in the squad been able to maintain this consistency, they might have won the match.
Maybe we won't see Lucknow Super Giants in the top four of the table due to defeat in this match. They have won only one match in their last 5 matches. Lucknow Super Giants' chances of qualifying for the knockout round are slowly diminishing.
LSG's bowlers could have bowled a little more economically but they failed completely in terms of bowling and the responsibility of the match had to be taken entirely on the shoulders of the batsmen.
In the place where about 12 runs should be collected in every over, if less than 10 runs are collected in any over, then the batsmen have to be under a lot of pressure to reduce the run gap. The batsman was dismissed and returned to the pavilion. If the bowlers could have performed their duties well, the result of this match could have been different.