I think the "full stack" or "software engineer" positions are either at small companies that need flexible employees or cheap ones thinking they can get 2 of them for less than 1 frontend + 1 backend and of similar quality.
Another category could be startups even not so small ones that leverage backend-as-a-service and their 'fullstack' devs are mostly frontend ones that can read/use third-party APIs.
So to answer your question, yes. I don't think lowcode etc produces top-tier UX and until then good frontend devs is a competitive edge. Until its not a competitive benefit, there will be a market.
Think about future user interfaces on the web: peoples' expectations for quality are becoming much higher and the market might majorly start to trend towards PWAs that have to try and rival Native Apps in quality. You need seriously sharp devs to pull this stuff off at a high level and make it work fast.
Additionally, we're just getting started in terms of metaverse and 3d stuff. Forget Zuckerberg's nonsense, but just think in terms of what an actual good browser based 3d world might look like with webgl and shaders: you need talented front-end devs to push the limits on that kind of stuff.
My main area of expertise are C++ networking libraries. I wyote and maintain one myselg.
First of first was: webmaster
Then it was: web designer (did it all)
Then: web developer
Then: frontend dev / backend dev
Now: full stack/software engineer
From a back end perspective, the back end has to check inputs coming into controllers and have tests around what has to happen before doing DB operations so a lot of the work in front end to do similar seems redundant.
All that being said, there is still a lot of work that goes into building a front end for an application. Even if it is back end code generating the HTML/CSS for page fragments, they still have to work in a cohesive way on the front-end. If you can be conversant and learn similar things (maintaining state, validation, tests) in whatever back end language is used then you should be fine.