The prophecy concerning the '70 weeks' in Daniel 9:24-27 outlines a timeline for specific events related to Israel and the Messiah. While interpretations vary, what is the primary theological significance of this prophecy, particularly concerning the transition from the Old Covenant to the New?