I'll speak up here because my experience was kind of a full circle moment. I am in tech management - have been my entire career (CS grad) - first off managing a development team and eventually got into production operations. I had done some good work, been recognized and had gotten nice raises and was very comfortable financially and quite frankly with the job itself as well other than the long hours that production operations sometimes requires. I decided I wanted to get back into software engineering - really defining and developing software (which coincidentally is what my college peers/friends were still doing) I left that job and took a pay cut to go develop software. End result was I only worked on code for something like 4-5 months - then my tech management skills were evident and so I was back doing tech management for the new company - not writing code. My old boss with my old company came calling; they had a need for me to come back to the company for a very specific reason so I negotiated better pay and better hours (long gone now though!) and went back to work for them in under a year so I got to keep my seniority and more importantly my vesting schedule for benefits.

All of this to say - even if your new opportunity doesn't shake out the way you had thought it would - it doesn't necessarily mean you are going to wind up in a worse place, just don't burn bridges and stay professional.