Is SEO content writing still relevant?

Yes, SEO content writing is still very much relevant, arguably even more so than before. Both traditional search rankings and AI Overviews depend heavily on well-written, genuinely useful pages as the raw source material they actually pull from.

What has changed is the bar itself. Generic, keyword-stuffed writing that once ranked reasonably well now gets buried under Google's helpful-content systems, while clear, specific, well-researched writing performs noticeably better than it used to.

The skill of writing for both a human reader and a search algorithm at the same time has not gone away at all. It has simply gotten more demanding to do well.

Meeting that higher bar automatically, on every page, is the job automatic SEO software does.