You're looking for cooperative board games.

One of my favorites is Zombicide: https://www.zombicide.com/en/

Although I'm not sure it's suited for kids, when I start playing I always get hooked and then it's sleep time haha.