Being a production support DBA is like any other 'niche' title/occupation within IT. There are always tradeoffs in salary, working hours and benefits both within a given company and between your company and others.

I personally have been a DBA for 28+ years, all but 5 of them as a 'pure' production support DBA. My limited development DBA time was rewarding but was too political and schedule driven basically leading to tremendous swings in stress based on where things were in relation to the project life cycle. As a production support DBA things are actually more predictable. Sure there are cycles related to business activities, scheduled maintenance and upgrades. Needles to say the potentially ever present, all important issue of dealing with outages that can crop up at any time. But how is that different from issues that a development DBA faces ? Sure, both have 'expenses' associated with them for the company's bottom line. In production, outages cost revenue. In development bad queries, tuning and other issues cost developer/development time which is also money. Missed deadlines, over scheduling and long hours during 'project cram time' also ramp up the 'cost' paid by the company. Oh, did I mention that 'stress' is a given no matter what since you are the DBA.

The real question to ask is 'Will this role be fulfilling for me ?'

Above all, 'Know Thyself' !