Why did the Opportunity Capture API create a Lead but throw an error when creating the Opportunity?

This is the expected behaviour. In the opportunity capture flow, a lead is created first, and then an opportunity is created. So even if opportunity creation fails, a lead is still created.

To know more, see Opportunity Capture API.