Besides, it's terribly self-centered. If you're taking care of an elderly parent or someone with a terminal disease, then it can be macabre to be so focused on your own mortality.
I don't see how it can be motivating. But perhaps I'm missing a key insight.
That's funny, it's not until I've gotten older and closer to an actual end that I start finding it motivating and not just distracting and stressful. I guess when I was younger I was more panicked with death.
Of course it's not meant to be accurate, but meant to instill "live now" instead of "live in the future", meaning I want meet more with people, stop working as much as I do and do what I enjoy, etc.
It's not really a focus, it's something I happen to accidentally glance at in something like a weekly basis. It's not hanging on the side of my display, so I'm not really "focused on my own mortality".
Personally I have https://www.bryanbraun.com/your-life/weeks.html printed and hanging on the wall next to me, and each week I fill another square.
Having a real-time view of how long we have left to live have always filled me with energy and hope, somehow. But similarly to you, many people seem to think it's macabre/bizarre.