Secret Service sources familiar with the failed assassination believe the small caliber, long distance, and shooter’s debilitating health contributed to the missed shots