Creating a sprite that sits flush on a terrain

You could do a line pick straight down and find the collision normal and align to vector or rotate to the angle.