Did Snowflake ended up completely re-engineering the Native App Framework from June 2022?

You are correct. Snowflake did re-engineer the Native App Framework in June 2022, and it was back in Private Preview from June 2022 to June 2023. The re-engineered Native App Framework is more powerful and flexible than the original framework, and it provides a number of new features, such as:

Support for more programming languages, including Python, Java, and Go.
The ability to build more complex and sophisticated applications.
The ability to integrate with other Snowflake features, such as Snowpark and Snowpipe.
Snowflake released the re-engineered Native App Framework in Public Preview in June 2023. The Public Preview is available to all Snowflake customers, and it provides a way to test and evaluate the new framework before it is generally available.