The 0.975 number is the probability needed for looking up z-star in tables, or for using the InverseCDF function to get z-star.
The end points of a 95% confidence interval are the points at the ends of an interval that includes the central 95% of the probability in the sampling distribution of the underlying test statistic, but instead of giving those points directly, tables of the sampling distribution give points such that some fraction of the probability will be to the left of any point in the distribution, so to use those tables (or the InverseCDF function) it is necessary to work out those probabilities. For a 95% confidence interval, the end points of the central 95% leave 2.5% the left of the left end point and 2.5% to the right of the right end point, which leaves 97.5% of the probability to the left of the right end point. So to get the end points of a 95% confidence interval, the points that are needed from the table (or from InverseCDF) are the point that gives 2.5%, or a fraction 0.025, of the probability to the left of that point, and the point that gives 97.5%, or a fraction 0.975, of the probability to the left of that point.
So the need for the 0.975 number is simply a consequence of how probability tables and the InverseCDF function work. Tables (and functions like InverseCDF) are based on probability to the left of any point, rather than points that include some probability around the center of the distribution.
The origin of the 0.975 number and is also described, with illustrations, in lesson 16 "Computing Confidence Intervals".