The thing that frustrates me is it’s possible to know how to do both. I have worked with multiple people who are quite proficient in both areas.
Cloud has definite advantages in some circumstances, but so does self-hosting; moreover, understanding the latter makes the former much, much easier to reason about. It’s silly to limit your career options.