The one other wrinkle (potentially) I’ve just noticed is the fact that the insubstantial nature of the weapon is part of the effect rather than an explicit restriction or limitation. There are advantages and disadvantages of it being insubstantial which is why it having it as part of the effect makes more sense than as either explicitly. I don’t think it impacts this particular advanced spell, but thought I’d mention it.
With a sweep of his hat,
Paul