This is a weird response, but could it be his bed itself? I had really bad night terrors until I got rid of my bed and got a new one. I’ve had no problems in 2 or 3 weeks.

I second the over heating thing. I bought cooling sheets and they are amazing. They are on sale at Kohl’s right now for $45-$50. They are usually $100