The late Whitney Houston plays mom to a 1960s girl band in her final screen role. Due out in October.