There have been a few films made for songs.
Right off the top of my head I think of Jailhouse Rock, Harper Valley PTA,
Earth Girls Are Easy, Jolene, Convoy and Born in East L.A. Some novelty
songs were made into movies like Take This Job and Shove it.
Not really common but not uncommon either.