The worst part is that if Picard was released under it's own universe and cast of characters, it's might actually be a fair to ok watch.

Sure, it has some internal inconsistencies but most stuff does these days. The major lore issues are the biggest paradoxes and failings and they would have been completely eliminated by just not pretending it's Star Trek.

But the story itself definitely isn't good, so the only way to get some diversity hire script made is to attach it parasitically to something people already like.