Sounds like a great idea, but difficult to achieve. The announcement blog post was almost 5 years ago, do you know maybe what the impact of this project has been in practice?

There are yearly releases of the standard https://data-apis.org/blog/ and I often see it ref'd on issues in individual libraries (numpy, pytorch)

See also funding from CZI (on the blog)

Subjectively I do find it helps with consistency -- and when things are not consistent, it's easier to discover what's different and why

edit: but I completely agree with this post and the follow-up from the same author on "dumbpy". At least at first blush, I need to read in more detail.