This was not meant to be but Gordon did become Lieutenant Governor in 1840. However, the governor, William Woodbridge, resigned in February 1841. As a result, Gordon became the state's third governor (albeit in an acting role) and served the rest of Woodbridge's term. He was unable to attain public office afterward but was appointed U.S. Consul to South America in 1850. His term ended abruptly in 1853, however, when he accidentally died in a fall.
As for the mansion, Gordon's widow owned it until 1882. Subsequent owners lived in it until 1967 when the owners sold it to the local chapter of the Daughters of the American Revolution, which owns and operates it today.