I've seen a fair bit of discussion about this, and so far, every author who I've seen talk about this has said they took the deal and came out behind, or they refused the deal but would have come out behind if they'd taken it, ie, subscription revenue ended up exceeding the offered advance.

I imagine there must be some authors out there who didn't mmet Substack's expectations, but they're apparently few and far between.