From what I've seen, there's enough demand in any infosec field for you to find a job in the specialty you want. But that depends on where you want to live and the kind of businesses that are around.
If you do not like coding, you might dislike cloud security even more.
At my workplace (a infosec audit and consultancy company), most of the new applicants want to do red team or pentesting, because that's what appears to be the most fun. However, demand in red teaming is pretty low, so low it does not even appear in the report you cite. Pentesting can be integrated into more general audits (web, app, infrastructure) and the skills can be useful in incident response.
When we recruit, the most important "skill" we look for is curiosity. Because the technical skill level out of school is so low, it does not really matter. What is important (for us) is how fast you will learn the trade while on the job. Keep in mind that half the trade is composed of social skills (writing reports, interacting with clients). Our pentesters only spend about 10% to 20% of their time actually performing pentests.
If, however, you want to work in a company developing products or services, things will be different. I think the report you cite match more those profiles. But you might as well forget red teaming, because the only positions available in the companies looking for internal red teams will not be for juniors.
Anyway, that's only from my point of view (too long for a comment), YMMV.