Coherent versus incoherent excitation dynamics in dissipative many-body Rydberg systems