Despite President Donald Trump's hope that virus will 'sort of just disappear,' cases are rising in 40 of 50 US states