Fewer than half the public believe religion is a good thing for the country, with younger people in particular failing to be impressed.