I'm not sure here, but I think weather could play a major role in disrupting launches, greater than with jet liners, right? And not just due to windy conditions (which planes can better withstand up to a certain point), but also rough waters. Another issue is noise. I don't see rockets happening that close to shore in large cities. A long pad-to-city commute, with ship trip included, would be another inconvenience.
However, in practice a rocket could be designed to fly in much more severe weather than is allowed for most launches today, it just takes designing it to do so. Because of the huge cost of rockets today designing a rocket to fly through adverse weather would add additional additional manufacturing cost onto each launch, which is not a good tradeoff. But if you can ammortize that over many flights, then it's not a big deal.
Think about ICBMs and SLBMs. Do you think there is someone sitting in a Minuteman bunker looking at the weather, ready to tell the launch officers just after they've turned their keys "sorry fellas, I've overriden your orders, we can't launch today, the weather is too crummy, oh well, better wait until tomorrow, if there is one"? No, missiles are designed to launch on a moment's notice, and be capable of successfully hitting their targets even if the local weather is terrible. Their designed to be able to launch through thunderstorms and experience only a small percentage of losses in the most unusual conditions. Similarly, any orbital rocket can be designed to be able to launch through most typical severe weather events, with only a small percentage of conditions (compared to today) requiring a scrub because it would endanger mission success.
The degree to which SpaceX will do such a thing is unknown, but it's within the realm of possibility.
Also, it should be noted that a major reason weather has a historical role in disrupting launches is because one of the best locations for launches in the US (Florida: Easterly coast, as close to the equator as possible) is also one of the few places on Earth with the most thunderstorm activity (roughly one out of five days in Florida has a thunderstorm). The vast majority of other locations on Earth don't experience nearly the same level of launch-risk inducing severe weather.