Move most of python sdk README.md to website #18147
Description
The content should partially go to top level README.md and partially to the website.
Imported from Jira BEAM-1359. Original Jira may contain additional context.
Reported by: altay.
{{ message }}