The performance of spherical wavelets to detect non‐Gaussianity in the cosmic microwave background sky