If you fly into an airport no-fly zone, it's like the drone has hit a soft, invisible wall.
You can fly along it but you cannot fly through it.
It's probably only the USA that has such things.
I've never heard of any other country having official temporary no-fly zones for sports matches.
The usual "horror story" is about people who launch inside a NFZ and are impatient.
What happens is that they launch before their drone gets good GPS location data (which would advise them of the NFZ and prevent launching).
They launch without GPS and soon after, when the drone acquires GPS, it starts to autoland.
It's easily prevented by waiting for GPS before launching (which is normal safe practice anyway.