What is Snowpark for Python, actually?↗

"In June 2022, Snowflake announced the public release of Snowpark for Python. But it's hard to tell what it actually is. It turns out to be a confusing collection of libraries, features, and other stuff.
Snowpark for Python is made up of: 1. A Python execution engine hosted on Snowflake's"