H\"ormander's theorem for rough differential equations on manifolds