I really don't think that there are many pools or miners left who care one way or another, one of the exceptions is Eligius. That pool is actually voting against P2SH because of silly implementational debates. From all of this I've come to the conclusion that this issue is one of the biggest problems for Bitcoin. If another large change is required in the future, I'm not at all certain if it can be done. This will leave Bitcoin vulnerable to competition from newer cryptocurrencies that have no such problem.
Then again I feel that this process of basically "forced upgrade" will wake up many miners. They need to fucking wake up because we're part of a technology in development, not something that will just stay the way it is for forever and ever. People who want it to stay like this forever have no clue about anything.
One future issue I think could require big upgrades is the scalability of Bitcoin and I think this whole P2SH issue could work as something that prepares people for that. Regardless, it's really important for Bitcoin that P2SH is implemented smoothly and securely, further issues with getting miner support would be catastrophic, I for one would be very skeptical of the possibilities of any bigger developments in the future.
This is not even about the users, it's about the backbone of the whole network. It's an added feature, users do not need to upgrade and they can continue to use Bitcoin as they do now, if they wish. Miners need to get used to the fact that they might need to upgrade from time to time.