I run a built-in Windows diagnostic tool and my battery stopped draining battery on the sleep mode.
Windows 11 24H2 has fixed the Modern Standby battery drain bug that caused laptops to wake unexpectedly and overheat in sleep mode, now limiting wake sources automatically.