Plan B
After discovering the state of the wood under the spray foam, and discussing the new situation with the structural engineer; we decided that the only solution that was sure to keep our foundation from crumbling out from underneath us...was to replace it.