what wrong when a man loses his erection during intercourse

A lot of things: he could have been drunk, tired, had to urinate, is taking a drug that affects his man parts, is old or he's not attracted to you.

If you're talking about yourself see a doctor if you need to know what's wrong with your tool, no one is a doctor here and Sue doesn't even post on this site. Wasn't her show canceled?