Water baptism in the name of Jesus Christ by dipping in, under and out of the water represents Jesus' death, burial, and resurrection. Which is essentially the gospel message. So we baptize in the name of him who died and lives for us. Having ourselves publicly and symbolically identified with his name and the gospel message. Exactly as the disciples did throughout the book of Acts.
Only believers should receive baptism since Philip underscored the need of believing with the heart before he would baptize the eunuch.
Baptism does not save a person because Simon the sorcerer received baptism and remained lost.
"Baptism" of infants is not biblical. And is more akin to the Evangelicals who hold "baby dedication services".
Baptism of believers in Jesus' name by pouring or even sprinkling doesn't symbolize the gospel message. But might be OK when enough water is not available or conditions do not allow.
Does baptism in Jesus’ name contradict Jesus’ command to baptize in the name of the Father, Son, and Holy Ghost? No, because Jesus Christ is the name of YHWH the triune God.