I used to have this problem terribly with a Chrysler Grand Voyager, they use relays to switch everything and they’d fail, get stuck and typical American car build quality things would break and not go to sleep. In short (no pun intended lol) the battery was forever draining. I tried numerous new batteries, cutting the try so I could fit a much bigger battery in, pulling the fuse for the built in amp all sorts and it still happened. What solved it in the end was a good lithium 12v car battery also weighed about a fraction of a normal lead acid battery.
Speaking of I really don’t know why they still insist on a 12v battery designed in the 1850s. There’s no technical need for a 12v system you could easily set the car up to use whatever voltage you wanted, on top the car could still output 12v via DC to DC conversion. You could have a car with EV battery and you could tap off 12v directly from the main battery bypassing the contactors and use that to start the car. You’d knock several kg off the weight of the car and remove the biggest failure point for all EVs car manufacturers are still designing cars with the 20th century mindset in this regard and it’s a real shame the 12v system caused me no end of grief on my MG ZS at one point and I fully expect it to happen again to the Enyaq at some point.
Have to wonder at the quality of modern car batteries too they seem to get less and less reliable at one point you could buy them with stupid warranty now you’re lucky to get 3 years from them and they fail earlier too. Can’t help but think the accountants have gotten to the bill of materials for these like they have with all other car parts