Yes, it has failed and it will fail for anything where it all depends on your own wish. I mean unless something/someone forces or reinforces you, you won't be losing your money or time easily.

Take youtube for example, it forces audience to watch the ads and distribute a portion of that money to creators.

For SN, it's a little different, but it has those incentives which drive people to engage with each other.

Nostr doesn't have any reinforcement or drive for audience to zap content. Remember zap is real money so they can't be in the same number as you see likes on platforms like X or youtube.

I'm not negative about future of V4V. I think we'll see some very good advancements in near future.