It was a partial success and a partial failure. All the engines worked up to hot staging. Starship managed to successfully separate but hot staging destroyed the booster. Starship didn't make it to orbit, it lost control and was automatically destroyed. So there were some successes but also failures. SpaceX is still years away from being able to fulfil their contract to NASA for the Moon missions.
They did better than the previous launch, they made large incremental improvements. A highly successful launch by any objective standard. A failure would be performing worse than the previous one.