Beyond the mom-and-pop flower shop down the street or the friend that needs a portfolio site...not so much. Squarespace is good for the aforementioned users because the platform makes it hard for them to create bad designs and do stupid things. Putting either of those types of users on a Wordpress site would just be a total nightmare.
HOWEVER, if you're even mildly tech-savvy, Squarespace (or site builders like Wix) become frustrating and limiting almost immediately.
This is why I believe Webflow is ultimately the answer. It addresses all the downsides of Wordpress with none of the limitations.
I think 5 years from now, Squarespace/Wix will completely own the mom-and-pop and portfolio space.
I think Webflow will ultimately own the space inhabited today by Wordpress (as well as static site generators), and be powering the marketing & content sites for most businesses. Which is where the real money is.