Wooden remains of two Roman wells - one of which had collapsed before it could even be used - have revealed "a failure of Roman engineering on an industrial scale", an archaeologist said.