Cloud is taking a taxi everywhere, bare metal is owning your own car.
In one case, you pay a premium so that somebody else worries about all details and maintenance, and in the other, you take on that burden but don't pay the premium. This has always been true for everything where a service is provided to you.
Great if your needs are small or not well known because there is no initial investment, but bad in the long run.