I worked in Corporate Finance for 5 years and now consult to the function...this is not "wrong" per se, the math behind the financial models that most companies employ is not rocket science. It is not hard to come in to an F500 Corp Finance environment with good excel skills and impress people.
That said, the amount of ways I've seen individuals fall into serious modeling errors because they don't understand, and I mean really understand, 1. model design and 2. financial theory is staggering. I mean simple stuff like not understanding how Excel's base NPV/IRR functions work can have dramatic impacts on valuation. I am not even talking about understanding mid year discounting, not understanding adjustments to EBITDA, not understanding balance sheet/cash flow consistency, which are more intermediate/advanced subjects yet still critical.
A lot of that comes to the fact that most people in FP&A are closer to accountants than finance professionals. It is staggering the number, and size of companies whose FP&A people have no idea what their projections mean for the Balance Sheet and for Treasury folks to have no idea how to accurately analyze a P&L.
On outsourcing it is common that a lot of the "reporting" aspects of the work is not in NA any more or has been automated. What other posters were mentioning about the ability to put together simple schedules that aggregate different data sources is a good example. But I think there is still plenty of room to get a foothold in most companies owning the "analysis" aspect of Corporate Finance. That may change soon-ish as better tech-enabled solutions like Alteryx gain adoption. But that's still in the early innings, in my experience.
BUT, while good analysis is still enough for a career foothold, it is still maybe ~20% of the value-add for Corporate Finance. Helping to keep the books well is a big component. Reporting is a component. Good analysis is a component. But the last, and IMO, largest bucket is using the analysis to drive results that impact value. Said in a less jargon-y way, first you have to convince people in Corp Fi. a. that your findings are right and b. that they matter / are valuable THEN you have to drive on them to get others in the organization (marketing, ops, etc) to actually change their day-to-day behavior. Often without a direct line of authority to those outside finance. That takes real people skills, "project management skills", and the ability to influence. It is rare that "sitting in your cube being smart" is enough for a sustained career in a lot of places, in my experience - even in FP&A.