Move from WordPress to Webflow without losing SEO or causing 404

Correct, you CANNOT use wildcard redirects for this, as not everything on your existing site is a blog post. (if I understand correctly, you have other static pages which are NOT blog posts, and you don’t want to redirect those.)

So if you are hosting with Webflow, the only way is to manually create the redirects.

The good news is, there doesn’t seem to be any limit on the number of redirects you can create. (tested up to 1000)