Your pump is undersized and cavitating or unable to get required influent flow and cavitating. As you said if this pump can not get enough water because of the location next to the well floor it will cavitate. Somehow drawing air from a leak in a line above the waters surface (Venturri effect) could also be a possiblitiy. Make sure all connections are secure and sealed properly.
