I didn't say "small". Streaming can certainly allow a movie with a $1m-10m budget to turn a profit. I am mostly worried about the mid-budget standalone movies that are targeted at adults. Movies like Arrival or Knives out are recent examples. I'm not sure streaming works to the same extent for a $30m-60m movies like that.
It doesn't make sense financially. Arrival had a budget of $47m. The general rule is that marketing budget for a movie is 50% of the production budget. That leaves us at $70.5m to break even. At $15 per month, you need that movie to generate 4.7m new subscriber-months to be worth it. Is releasing Arrival on HBO Max going to be the deciding factor for 4% of US households to subscribe for a month? I doubt it.