I might quibble slightly with your framing (that they didn't do the title favors but it didn't change much). While not expecting a Bucky-level return of Ben, it's certainly possible they could have put the title in a better position to be successful. The creative team is, at a minimum, solid. It was unclear at the outset (from solicitations), though, if Ben was going to be an evil villain, a character trying to redeem himself, or a return to the Ben some of us remember from 20 years ago. A Clone Conspiracy story that was both better and created an easy-to-understand thesis for Scarlet Spider might have gotten more initial interest, allowing the creative team an actual opportunity to keep people around.
In the interest of fairness, I'll make the counter argument that Spider Woman basically had that exact set up coming out of Spider Verse (for a better known character) and only got 23 issues (27 total, but 4 were part of SV).