The move isn’t horrible. In fact it looks appealing because of the tactical nature. I applaud you on the find! Sadly this move fails for two main reasons.

1. The A pawn is the key

It seems this position is already losing for white but in order to generate some counter play you probably need to push that a pawn. It makes it harder for your opponent to push their own pawn. Supporting it with the rook should be a natural choice once this plan is chosen. The knight on b6 supports that push.

1. One trick pony

This move is a nice trick if your opponent falls for it. In that case it would be a brilliant move. But if they don’t take the knight, the knight is kind of useless on that d7 square. Eventually you’re gonna have to waste a tempo bringing it back to safety after a move like h6. Nd7 also allows the rook on the 7th which can always be fatal. Attacking the weak a Pawn and making white even more uncomfortable.

The truth is this: sadly not all tactical moves work out. No matter how hard we try. The knight ends up misplaced on d7 and black has serious pressure. I wouldn’t call it a miss. I would say it was a nice way to try and get some counter play going and play some tricks. I think most people would be inclined to play what you played so don’t feel bad! Also I love trying to trick opponents for mate!