No, it's a quirk of the player showing up as the best overall player who is not a starter for that week.
Because the player is an RB, he shows up as an offensive player of the week. But since he is a non-starter, and he was better than all the defenders that week, he also shows up on the "defensive" side.