It was not the glamorous ending many had envisioned for the beloved TV character's journey, which began with Sex and the City in 1998 (pictured)