I'll put in my two cents. I was unhappy in a job at a large public company because there was no growth opportunity. I left for an even larger company (although private) for a job similar to yours.
I was excited because it was the job title I wanted, but I was slightly lukewarm about the job - it wasn't exactly what I wanted. I was so desperate to get out of my job that I went ahead. Since changing jobs, I'm no more happy. While my job is better and is the career change I needed long-term, there are a lot of things that make it worse.
I deal with waterfall and agile, and it doesn't matter - still deal with the same shit - so it shouldn't affect your job choice.
I'll just say, if you're going to move and take a job you're just not feeling, I'd really reconsider why. Especially if it is somewhere you don't want to move. If I knew what I know now, I may have reconsidered making the change because I had a couple things in the hopper, but they were at least a couple months out, and I thought bird in the hand....