Several pilots have published videos of overflying the Oroville Dam. Here's one from a guy who makes some good videos:
https://www.youtube.com/watch?v=q2YHGR3kVLk
The money shot is at 2:25
https://www.youtube.com/watch?v=q2YHGR3kVLk
The money shot is at 2:25
If the emergency spillway failed, it could lower the water level in the reservoir by 30 feet. That would be catastrophic downstream, of course, but probably wouldn't have much effect on the boats.
My wife, a Water Resources Engineer, is. If the damage to the spillway starts to move sideways, or uphill too far and too deep, you could see the main dam get damaged. It's not as likely as the emergency spillway dropping things 30 feet, as you say, but it's still on the table as a worst-case scenario here.
Well, let's hope for everyone's sake that this worst-case scenario does not happen!