They were effective to a point.
On the occasion when they did hit a ship, the damage inflicted sometimes was severe.
Look at how many carriers that were damaged bad enough to have to return to port for repairs for example Bunker hill.
But of course the Japanese lost hordes of aircraft and pilots for no gain, so its hard to say it was a success
Hope this helps!