QA to Product transition. Is it worth it?

If you mean product owner or product manager, go for it. Upskill as needed and try to get responsibilities that your current product person is willing to mentor and delegate to you. That can count as product experience for the target roles in the next company.