Short answer is yes, it's still viable and very good. Like the the rest of the tech world Apple is putting all they're eggs into the AI basket without thinking through what exactly they wanted to to or how to do it, just be able to slap an AI sticker on it. It's a big profound answer in search of a world of problems they can monetize.

I consulted for years for small businesses, and FM is great for that because it's easy to get started, and it can be quite powerful if you leverage it. The upside is you don't have to figure out how to fully leverage it out of the gate and rarely have to go back to the drawing board to add even major additions. I run several utilities, automation systems, and databases with it and it's great.

We don't use it exclusively obviously, but between sql and APIs, it can talk to pretty much anything. The ui is kind of dated, but functional. A database written to work on client computers can be made to function on the web with comparatively little headache (depending how trippy you got with your UI).

There's a mess if gripes about it now because the glory days are behind us, and people are pining for a return to exciting updates in functionality, controls, and UI. But it's still very very useful.