Python: Enable instrumentation by default #5749

Based on user feedback, we will enable instrumentation by default to reduce user friction.

We will still allow user to disable.

An optimization we can use to reduce the overhead in populating span attributes while not exporter or provider are configured in users' app, we can use span.is_recording() for gating expensive opeartions.