You’re absolutely begging for moisture problems if you put spray foam in there. It should be open exactly like it is, albeit cut closer to the wall. That really won’t stop bugs anyway, you’re much better off treating the perimeter and plugging exterior access holes.