I had an erection before and I rolled over to my left side and then it suddenly went really limp and now I have this dull ache. Could it be serious?

Penile fracture poss. Fracturing the erectile chambers of the penis does happen and can lead to problems. There are other possibilities including tearing a superficial vein. Get an asap referral to a urologist, they'll get you straightened out.