As TikTok's future in the U.S. remains in limbo, San Francisco startup Substack is going after video creators in a move to expand its platform.