Speaking on behalf of proponents of the separation of church and state:
It's not that Bush prays, we're opposed or that fact that he flaunts it in contradiction to Christ's teachings. The main concern is that he's the only one talking and not doing any listening.
Side note: if his successes are an indication of the results of his prayers, there's either an issue with his requests or the diety he's praying to.