I can't claim to be able to definitively diagnose and solve your issue here. But I can offer a few observations and suggestions:
All your backup drives show only a small amount of free space, on the order of 100 GB - 200 GB available for backing up. Yet your backups have been operating for between 1 and a few months only, a relatively short time to use up 90% to 95% of the space on those external Time Machine drives, which I assume are 2 TB or more in size.
I have two Time Machine drives and they are 2 TB in size, backing up about 450 GB used on a 1 TB MacBook Pro. They started in 2022 and now have 350 GB free, approximately.
I am guessing maybe you have some very large files that are modified frequently, maybe a virtual machine or some sort of large database? If so, one expects that to more rapidly use up the available space on the Time Machine backups. Time Machine also looks for 2x to 3x the needed space on the destination drive before it starts the next backup, why so conservative I don't know, but perhaps to ensure the drive does not physically fill up, which might make it unusable. So if your next backup requires ~ 40 GB, it might refuse to do the backup.
As others suggested, I would erase/format the problematic drive and start over with it, I would doubt its reliability now as a backup. You might also look to see if there are some very large items being backed up that change. Just logging in to a virtual machine and doing nothing and logging out can result in the entire thing being backed up as it looks "changed" to Time Machine. This is very wasteful and not what Time Machine was optimized for, so consider excluding those large items from Time Machine and instead doing separate clone type backups to a separate drive of just those few large items. Software like CCC and SuperDuper can be configured to do this and to efficiently do incremental updates to such separate clone type backups.
It also appears that at least some of your drives are infrequently used for Time Machine. If many days to ~ weeks go by between backups, the next backup can require ~ tens of GB (or more, depending on how you are using your Mac) which can make this problem (above) more likely to occur.