Beyond its growing stature as a publishing powerhouse, Substack is being increasingly pursued by brands as a distribution engine that funds should take notice of.