Weakening Ophelia still poses a risk of coastal flooding and heavy rain in some parts of the US