No, a pirated game cartridge cannot "kill" a Game Boy console. The hardware is robust, and cartridges are simple ROM boards. However, poorly manufactured bootlegs pose physical risks.
Legal Note: Downloading ROMs for games you don't own is copyright infringement in most jurisdictions. Support developers via official re‑releases (Nintendo Switch Online, Analogue Pocket, etc.).