CEO’s exit spotlights the growing issue of advertiser confidence amid X’s pivot to a subscription model.