Kaguya's Expansive Truth-Seeking Sphere has no special defensive capabilities apart from regular ones. Both it and Perfect Susano'o get destroyed. They'd most likely die considering it's a direct hit but end up regenerating after some time. They can have some body parts survive depending on whether the attack penetrates the defense or destroys it in the first scenario, because the latter would spread the damage and base it more on being pushed back rather than the bodies getting decimated as if the former were to occur.
I think you need to reconsider back on what you have talking about massive TSB. If those attack able to destroy massive TSB with ease, why Naruto(I only bring Naruto here) never tried to attack it using the same attack he used on Sasuke's Indra arrow?
And saying Kaguya if not Madara will die when facing those attack dismissed what Kaguya trying to do with her massive TSB.
Destroying whole dimension. Do you want tell us those pesky attacks can shake entire dimension let alone destroy it? And do you honestly thinking those two attacks can kill Kaguya(in this case Kaguya only) when she never had any fear to deploy massive TSB?
At bold. How die and regenerate can be in the same sentence?
Regeneration in fiction
Introduction
Regeneration or "regen" is a term given when a particular character can heal from wounds at an accelerated rate. Regeneration has different levels. The lowest levels of regeneration basically just increase your body's natural healing ability somewhat, so a wound that would normally take weeks to heal would take days or hours. More advanced forms of regeneration can regrow lost body parts, such as fingers, arms, legs. Even greater forms can regenerate after being decapitated or blown into pieces, and it goes up from there. It is also sometimes known as a "healing factor".
Types
Low: Faster healing ability for normal wounds
Boy Blue from Vertigo Comics, Naruto Uzumaki from Naruto
Mid - Low: Able to heal wounds that would normally leave large scars
Example: Blade from Marvel Comics, Kankel from Betterman, and Luciela from Claymore.
High - Low: Able to regenerate some severed body parts like fingers, arms, legs
Example: Several incarnations of Godzilla from Godzilla
Low - Mid: Able to regenerate limbs/fatal wounds. Still die from decapitation
Example: Inuyasha and Sesshomaru from Inuyasha, Isley from Claymore, Orochimaru from Naruto
Mid: Able to regenerate from decapitation
Example: Piccolo from Dragon Ball, Kagato from Tenchi Muyo!
High - Mid: Able to regenerate from being blown into pieces
Example: Dio Brando from Jojo's Bizarre Adventure, Victor from Busou Renkin, Naraku and his incarnations (with hearts removed) from Inuyasha.
Low - High: Able to regenerate from a puddle/drop of blood, or a small piece of your body
Example: Lobo from DC Comics, Alucard from Hellsing, Cell from Dragon Ball, Homunculi from Fullmetal Alchemist, Remilia Scarlet from Touhou.
Mid - High: Able to regenerate from being vaporized/dust
Example: Majin Buu from Dragon Ball, The Incredible Hulk (Depending on incarnation and portrayal) from Marvel Comics
High: Able to regenerate from a single molecule/atom/particle
Example: Anthrax from Bastard!!, Cherubimon Virus from Digimon
Low - Godly: Able to regenerate as long as your disembodied consciousness exists/regenerate from other realms
Example: Doctor Manhattan from Watchmen, Spawn from Image Comics, Dark Schneider from Bastard!!
Mid - Godly: Able to regenerate from nothing
Example: Karukinos from Heroic Age, Milleniummon from Digimon
High - Godly: Able to regenerate even if your existence is erased and the dimension/universe you're in is destroyed.
Example: Swamp Thing from DC/Vertigo Comics
Technically they dont die if they still can generate.
Example of statement character use and you can find it if you read manga/comic:-
"It hard to kill him bcus he can regenerate even if we blow him to oblivion"
:axedance: