Filtered water is still tap water -- filtering does not remove the calcium and magnesium normally in water that makes hard water scum. You need to use distilled, deionized, or demineralized water or even rain water to eliminate the cloudiness when you do a clarity test. IMO, a cloudy diluted soap due to the nature of the fats or other ingredients in the recipe is fine -- a cloudy diluted soap due to the soap turning into soap scum is not so nice.
With about 30% castor in the recipe, the shampoo may not foam a lot. Castor enhances bubble stability when used in small amounts, but it depresses lather in large amounts. I don't know where the turning point is for a given recipe, but I'd expect 30% might be pushing it.
Also the amount of dilution may be an issue. Unless you used high oleic sunflower, the oleic acid content in this Snowdrift recipe is fairly low. That means if you want a somewhat thick soap without adding a separate thickener, you probably can't use that much water. By contrast, look at Irish Lass' liquid soap recipe (the one Susie gave in her post above). The IL recipe has a high % of oleic acid and is diluted much less than the Snowdrift recipe -- there's more than 50% actual soap (fat + KOH) in IL's diluted soap. By following the dilution rate as given for the Snowdrift recipe, the diluted product has about 30% or less of actual soap in it. That's another reason why you might not be getting much lather --> less soap = less suds.