The normal Linux systems administrator role eventually will go away. Many people don't believe it but it eventually will because it's a job that can be automated away.
The use of Linux as a systems is not going to go away. The need for people who know Linux is ever growing. A bit of a conundrum.
You are only seeing two polar extremes here and it doesn't actually reflect what the market represents. Competent linux sys admins are moving into devops and sre type positions where they are taking on more development responsibility. Focusing on automation and building tools that facilitate developers rather than transactional systems administration duties of the past.
Many companies now hire developers and devops/sre candidates from the same pools.
So there's a middle ground for you. If you still like linux then I'd suggest you really hone up on your scripting and really learn your networking and Linux internals and move to one of the mentioned positions. They are a plenty.
Even with that middleground, devops jobs are still going to be in much less demand than dev, right?
It's still engineering, so that part isn't going away. Just pay no mind to the rainbows and glitter, unless that's your thing.