Reusable rockets likely got the same ridicule, as did fast satellite internet, self driving and fully electric vehicles.
I can understand that Musk does not have the most palatable personality, but floating ideas and at least attempting innovation regardless of outcome over a long time is a net positive for society and should not be discouraged.