You asked “which adobe app should i master with which i can earn my basic needs” with less competition. The answer is that isn’t the real question, because it is usually not about one app, it’s about production in general.
For example, InDesign and the others are just tools, like in a toolbox. No one uses only a hammer or only a screwdriver. What the professionals do is use the correct combination of tools in the most efficient sequence to meet the project requirements on time.
In the same way, learning a single app is often not enough. If you are hired to produce a job in InDesign, and you are an InDesign expert, that is great, you can lay out pages. But those pages usually need images and graphics. To produce the images correctly, you should know Photoshop well enough. To do the graphics correctly, you should know Illustrator. If they ask you to adapt the same graphics for social media, you should know Adobe Express, and maybe a little about animation. So to be better than your competition, you would need to understand the overall production requirements and how multiple apps need to be coordinated within it.
Then there is the question of meeting job requirements. Now you need to know whether your InDesign job is for print, or online, or what. Because you must set up InDesign differently depending on whether the job will be printed on a press, downloadable as a PDF file, or viewable as an EPUB document. Each of those uses different units of measure, different color models, etc. So your expertise must extend beyond the software and cover production knowledge in general. For example, if you become expert at how PDF production works, you could build a PDF book by combining InDesign, Photoshop, and Illustrator, but you can use the same knowledge to also do it using similar applications from other companies.
So don’t get trapped into thinking it’s only about a single “best” Adobe app. It is not about any one app from any specific company. It is about being able to deliver a finished product using whatever combination of tools is required to meet production requirements for a specific delivery medium.
And, I agree that freelancing in this area is more difficult than ever, first given low-cost international competition, and now AI might soon do the most basic jobs (look at what Adobe is starting to do in InDesign with the new AI-driven Auto Style feature).
Another thing...some freelancers became more successful because they developed better skills for marketing and selling their services. It set them apart from the freelancers who only know how to use software.