If you live in a place like Hawaii or Florida, then you could just drop a LiFePO4 battery in right now because there is very low risk of cold weather. Otherwise for a motorcycle you could use a surprisingly affordable
sodium-ion battery, or if you have deep pockets and need a group 24 battery even a
solid state one. But lead-acid performs very well at a good price for starting applications without any deep-cycles--there's a reason EVs come with one lead-acid 12v battery even if they have 480v or more in back.
You can actually just drop an AGM in place of a flooded battery but it may have a lower than expected lifespan due to insufficient charge voltage, unless you get particularly lucky and your car just happens to supply enough (which is a real possibility if you have to top-off a flooded battery frequently) or can be programmed to do so. Otherwise you would add a "diode mod" to adjust the voltage a little.
But that may not be necessary because there are some flooded batteries with the same type of VRLA and venting system as AGM batteries use to prevent water loss. Normal flooded lead-acid batteries have regular caps (which may be hidden under a sticker but are there + vent around the edges), while VRLA are completely sealed/plastic-welded except for a vent tube attached to a labyrinthine maze where water can recombine and be recovered instead of lost. These look exactly like AGM batteries but there may be small clues such as a green Delco eye which reveals it's actually a flooded type. So just look for batteries that do not claim to be AGM yet are clearly impossible to top-up + have a vent attachment for trunk-mounting.
Real AGM batteries of course do deliver more amps (from the greater surface area) + have much higher vibration resistance and don't have shorting problems from shed plate material (both from the fiberglass mat mechanically separating the plates). And seems like a deal at only $20-30 more, but those are for the Calcium-Lead models. If you really want an AGM battery that lasts 10+ years then you have to choose one that advertises 99.99% pure lead to reduce internal corrosion, and those cost more.
Flooded lead-acid often dies from an internal short in one cell. Normal use and especially deep discharges result in shedding of active plate material off--and it doesn't all get recoated back onto the plates when charged. If enough accumulates at the bottom of the cell, then you get a short across and fast self-discharge. Some manufacturers like Exide intentionally do not supply enough free space below the plates so the battery won't last much beyond the warranty period, so instead choose a brand OEMed by Johnson Controls (Clarios/Delphi/Varta) like Walmart's EverStart, or East Penn/Deka.
I don't usually buy AGM unless the car originally came with one, because I replace car batteries every 7-8 years
before they go bad to avoid problems, and both cheap AGM and flooded lead-acid last that long for me in a mild climate.