Honestly I don't think coming up with ideas for a story or the lack of a sequel for the game is a big issue for Detective Pikachu 2.
I think it's a really good comparison just because it's another big IP (honestly Pokemon and Pikachu are probably much better known with the general public than Dungeons and Dragons) with a similar budget to Honor Among Thieves. Obviously they're from different studios but with the Detective Pikachu sequel not getting much momentum I don't think Honor Among Thieves sequel will either when it comes in with lower final box office numbers.