No, while he might have believed in a bodily resurrection on judgment day, this was more of a superstition about the spirit of the dead being reincarnated as another human being. John had done no miracles (John 10:41), but a common belief of the time was that one who had been reincarnated could do miracles.
Herod is not confessing his faith or acknowledging that Jesus is the Messiah, but is plagued by his guilty conscience. He now saw someone reflecting the murdered John’s word (Mark 6:20), and so thought of a kind of resurrection, but was not like a Pharisee who truly believed in the resurrection
No, while a bodily resurrection prior to judgment day is perhaps something Herod Antipas could have considered, here we must rather think in terms of a superstition regarding the spirits of the dead being reincarnated as another human being1. John had not conducted any miracles during his life (John 10:41), but the common superstition of the time taught that one who has been reincarnated would be able to conduct miracles.2
Herod is not here confessing his faith or acknowledging that Jesus is the Messiah, but was plagued by his conscience. He had murdered John, and now saw someone reflecting the word of John (Mark 6:20), immediately thinking of the resurrection. One ought not to derive from Matthew 14:2 that Herod was a Pharisee who believed in the resurrection, but rather only in terms of a guilty conscience. There is no doctrinal conviction on his part here.3
2 and he said to his servants, “This is John the Baptist. He has been raised from the dead; that is why these miraculous powers are at work in him.”