Unless it leaks or something, a dead battery shouldn't affect a game working or not, only it saving.
Super Metroid will start you off with 0 Energy if your save battery is dead, resulting in you dying when starting the game. It's the only game that goes something like that, AFAIK.