I don't think most people are looking for $10/post. That's already semi-professional rate. If you look at freelance platforms you can find top notch quality for $15 already, and that's with a middleman and also PayPal. Those would be among the top percentile of authors on Hive quality-wise.

Currently, those aiming for more have multiple years of mileage already and a portfolio with previous publications in MSM. And, they are all being sacked and totally happy for Substack currently. But, often, that's also yet another level of quality again. And, of course, they need to build their newsletter up too. No visitors, no subs. Enjoy whoring yourself out on FB, IG, and Twitter.
And, the more people try out Substack, the more will be disappointed about their earnings because many won't get 10 subs for months.