Graphic video shows aftermath of accident involving former ESPN sportscaster Cordell Patrick, who was ejected from an RV after his wife fell asleep at the wheel