Is category management a good role at Amazon?

Yup! Been there, done that!
In general it’s a great role, be sure of the role - is it a category business dev mgr or category manager.
In the present scenario, You’re better off taking the former role.