Noth portrayed Carrie's late husband - financier John James Preston/Mr. Big - in all six seasons of HBO's Sex and the City, two forgettable film spin-offs, and the HBO Max revival