You're just creating more problems. If the first battery didn't last a new one won't either. Either the charging system or method is bad or the battery design is bad.
Purchase a tire inflator that is as simple as possible and is powered from the good old 12-Volt cigarette lighter.
Purchase a generic 12V battery charger from your local auto parts place, preferably with a cigarette lighter socket.
Purchase a cigarette lighter adapter similar to the below item to connect a female cigarette lighter to the battery. Make sure to use a fuse... Never connect a male cigarette lighter connector to a battery, especially without a fuse...
https://www.amazon.com/SPARKING-Cigarette-Lighter-Terminals-Extension/dp/B07RMH3R8P/ref=sr_1_5?crid=2Q4WUORSX4KB1&keywords=battery+charger+12v+automotive+cigarette+plug&qid=1696434404&sprefix=automotive+battery+cigarett%2Caps%2C104&sr=8-5