Give Windows Movie Maker a try.
I have used it to do projects similar to what you are describing and then burnt to a cd also using WMM. The cd's have played in 2 of the 3 stand alone dvd players I have access to. It may be a fluke, but wasting 1 cd to see if it works is cheaper than buying a programme that is too feature rich for you.
(next day) Sorry, I lied to you. I went and searched for the cds and neatly appended on them was "burnt onto cd with Arc Soft" (software that came with the camera!). Again sorry.
(ps. Noting your country, watch CTV on May 29th "Plague City". My daughter-in-law is the nurse Rosie. It is her 1st major TV role :lol: )