As of mid-2024, no new mainline Pokémon Mystery Dungeon game has been announced since Pokémon Mystery Dungeon: Rescue Team DX (Switch, March 2020), a remake of the original GBA games.
Spike Chunsoft (developer) has not announced a sequel. The series sells well but niche. Fans speculate a new Switch/next-gen title is possible but unconfirmed.
Recommendation: Play Super Mystery Dungeon (3DS) or Rescue Team DX (Switch) if you haven’t—they are the definitive modern experiences.