Changes made to non-dune pinned packages are not visible until `dune clean` is run

[gridbugs]

After dune attempts to build a non-dune pinned package, changes to the pinned package are not picked up by dune until dune clean is run, even if the attempt to build the pinned package failed.

Changes to the pinned package should be picked up immediately regardless of the state of the current project and trigger rebuilds as necessary.

Repro test added in: https://github.com/ocaml/dune/pull/10233