Re: What could possibly go wrong?
From whose perspective?
Boeing? Hardly - they're (re)using those propellant barges to move their massive cost plus payments so they don't care. It's also the closest to booster reuse they'll ever get.
NASA? Well they care - but they are at the mercy of congress critters who are using public money to fund re-election campaigns in the districts that make the bits.
SpaceX? The company doesn't really GaS although they're largely staffed with space geeks who want all rockets to succeed. They've got boosters almost as powerful that you can order more or less off the shelf (and re-use them) which would easily cope with the early Artemis loads (note - I think they would have issues with the capsule width though) and by the time Boeing et-al get Artemis II payloads ready I strongly suspect the Starship booster will be firing.
Blue Origin? Boeing/ULA MK2 - just funded by Bezos rather than the taxpayer. They'll probably have something in orbit around Earth by the time NASA are around the Moon and SpaceX around Mars.
Anyone living within 20 miles of the test? I suspect that they have ear plugs and strong windows.