You're leaving RAW territory here and supposing at RAI. I don't quite know what you're saying vis a vis the point. At least as far as a RAW discussion.
Well, that's not explicit in the RAW, so...
You can't have a RAW discussion when one person thinks "what the RAW says is in error and what I say is correct". That line of discussion is going nowhere.
The RAW as they exist are coherent. Animating undead is an evil act. Evil magic is a part of their physical makeup. As evil is part of their physiology, the rules regarding creatures to whom evil is inherent to their nature supersedes the rules regarding mindless beings being incapable of having an alignment. Thus mindless undead still radiate evil, and are subject to damage from holy spells and Smite Evil.
That's is consistent and coherent. Not a "failure of game design".
Except the opening of that paragraph "in some extraordinary settings", thus implying that everything that follows is a deviation from "ordinary" setting rules.
I suppose that's true. Fair point. But if the resurrected person was to later die, they still have a full, viable corpse from which to be raised.
And yet if you are killed, your hand chopped of to be used for Resurrection, and let's say the rest of your body is turned into a zombie before your friends get that Resurrection. That zombie is placed somewhere that is cannot be located with divination, or summoned, or located physically (say, a lead lined coffin with dimensional-anchor and nondetection permanently cast on it, dropped into the ocean), then no mortal magic in the game can bring you back to life. Resurrection will not make a new body from the hand, True Resurrection will not make you a new body.
Again, there is SOME connection. That is all I am saying. That is RAW.