Ultracold molecules in an optical tweezer array: From dipolar interaction to ground state cooling