Daniel Patrick Moynihan , the United States senator and diplomat , championed the project until his death in 2003 as a way of creating a grand public entrance to New York City and atoning for the 1963 demolition .