Dumb question:
are you sure the MB needs a CR2032 cell and not a ML2032 rechargable?
If you're charging a CR2032, it's no wonder that it dies quickly.
Yes very sure, it is an asus strix z270f gaming motherboard it requires a CR2032 Lithium cell battery.
I have an Asus Strix Z270e and, like yours, it gets turned off every night (and sometimes daytime too). That is really off - single switch kills all mains to the PC and anything not needing active power when I'm not there. It is now seven years old and there is no problem (touch wood) with the backup battery.
If yours is running out I would think the motherboard is at fault, even if you're using cheap and nasty batteries, since you shouldn't've had to replace the factory battery yet.