Research finds acceptance of need to plan for climate change but an unwillingness to pay for it with projects like sea walls