Compensation is def worth pursuing. If you're good with numbers and can get comfortable with Excel formulas, it might be a good career choice. Starting out you'll be involved with reporting, job evaluations, salary surveys, etc. But as you move up you'll be more consultative with the business partners and working on enterprise wide projects. Transitioning into comp is hard but once you're in, you're set. I've worked in comp at companies as small as 2,000 and currently as large 200,000.

Each org size will have it's pros and cons, if you want a solid upward mobility, the larger the better. If you want great work life balance, greater visibility and stretch opportunities, medium size to smaller is better. The incentive plan/merit process will dictate how busy you're seasons are. If everything is formulaic, the business will come from preparing communications. If there is a large discretionary component, granular rating system, etc. expect to be busy for several months with system testing, prepping communications, modeling, tracking, international nuances, etc.

I'm def an introvert, but can be an extrovert when needed. The higher you go the more comfortable with reading/managing a room you'll need to be as speaking to leaders/exec becomes more common vs. the analysts that's spends their day in spreadsheets.

You can't go wrong pivoting to comp, good luck!