It is extremely challenging! (Based on my brief foray into it.) But leveraging LLMs to create really good starting point for a new feature would reduce the amount of frontend developers needed.
I guess what I mean to say as SRE/Systems, we code so little already that it being able to spit out a CF template wouldn't reduce the needs for cross-functional ops type work.