Witnesses describe in blunt terms how former US president refused to heed advice of those closest to him, including family members