Barack Obama says public attitudes around gun rights have to be reshaped