While preparing for a live broadcast on Fox NFL Sunday, Terry Bradshaw mistakenly ingested a sleeping pill at the studio desk