MicroSD are notorious for being unreliable, especially cheap ones.
What MicroSD are you using?
To add more context, I only use TimeMachine for the use case "I deleted something I haven't committed to Git and want to revert to the state of 1h ago". My real backup is offsite + encrypted (Arq + paid GDrive).