I can't tell because of all the turbulence, but does your drain pipe end above or below the surface of the water in your sump? If it is above, you should probably put it below to minimize the turbulence. Also, if it is below, perhaps an elbow would help so that the water will "flow" more instead of just colliding with the base of the sump (just my .02, since i don't even have a sump yet
I am not really sure what the holes that you highlighted in blue are for, but I think the red ones are to help remove air from the standpipe. Not sure what help there is for the air intake issue, someone with more experience will have to help you there...sorry.