It worked. But it was a stupid call at this point in the game amd where they were.
Though I agree it is insane, it was something that making it, greatly outweighed the consequences if they failed.
They are playing against last season's SB Champs, against the best QB going at this time, and a HC that is arguably the best at this time. They were behind the 8 ball before the game even started.
Nobody was expecting something crazy like that, but by taking that shot, it allowed a few things to work in the Lions favor. First, of course, it got them new downs, second, it changed the momentum of the game, and third, even if they failed, now after doing that, it screams to the Chiefs, this coach is crazy, can't take anything for granted any more (Players, and coaches are now doubting themselves on what they expect the lions to do).
If they had kicked it, Chiefs probably get good field position, and probably score...At worse 3 more points.
Sometimes, if you want to be victorious, you have to throw caution to the wind, and attempt something insane to help you possibly change the momentum and do the impossible...Nobody wants to play a Rogue team, that is capable of anything at any moment.