Cutover role column from users table to user_details.onboarding_status

What does this MR do and why?

We introduced new field in user_details.onboarding_status to replace users.role. The new field has been populated since !175321 (merged), this MR cutover the code that uses users.role to onboarding_status_role.

Related to #498739 (closed)

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.