Appearing Friday on CNBC's "Squawk Box," former FDA commissioner Dr. Scott Gottlieb stated that the end of the coronavirus pandemic in the U.S. is "in sight" after Pfizer announced that its experimental antiviral pill slashed risk of hospitalization or death from the illness by 90 percent in a trial.