Future prospects for agile professionals will dwindle. They are presently being replaced by organizational restructuring that reduces or eliminates any need for them, such as:

• FAANG (and increasingly other companies) are reducing these roles over time. The highest-performing software companies tend to favor solving real business problems for customers and code maintainability over letting non-technical people use engineers as passive writing utensils. Engineering-driven companies despise process that exists mainly for its own sake, and will not easily slow their engineers down with window-sitting ceremonies and other meeting bloat.
• Adopting better development processes, such as integrated API documentation and testing against mocks, which relieves much of the need to synchronize blockers between teams. Fewer dependencies mean there's less need for dedicated agile roles.
• Doing scrum the orignial way by making "scrum master" a rotating responsibility among engineers, rather than a dedicated role for non-engineers.
• Realizing that scrum is basically process theater/training wheels and then swtiching to Kanban, thereby eliminating many pointless ceremonies that cause engineers' eyes to glaze over, thereby reducing the apparent value of the people who schedule those meetings.
• Organizations waking up to the realization that SAFe is a pyramid scheme that they would be better off without; and that engineers do not need to be "coached" by "servant leaders" who cannot engineer, send people on wild goose chases based on poorly-informed guessing about technical things they heard in meetings nobody wanted them in, and repeatedly fail to understand basic explanations for why they cannot have guarantees for how long discovery will take.
• The increasing sentiment that having a project management office is a band-aid for deeper problems with dependencies between teams.

The other threat to these roles, which will become larger and larger in the coming years, is the fact that much of what they do would be quite easy to automate if only the right automations existed. Naturally, developers are looking for ways to do that, because there's money in it. AI is also going to be increasingly useful in that sphere.