I think it’s small in the sense that currently people are using centralised hosts like youtube, Patreon and OF. If you want personalisation (email, NIP-05, website, etc) and de-platform resistance - you’ll need to at least control the domain.
And if you add in subscription services where to access content you need to use Nostr HTTP AUTH - then that can just sit in front of the CDN data.