My first reaction was "Holy shit...that is ridiculous," then I warmed up to it almost instantly. It gets Vince off my TV (sure, he will still be mentioned, but at least Shane will be doing the talking), and it is a genuinely interesting angle. I mean, until it's revealed to be Steve-O. Until then, the who-dunnit aspect will actually be intriguing to me. I mean, blowing up Vince is the best way to get a push like...ever. Except maybe next to beating The Undertaker at WrestleMania, but you need to be slightly elevated for that, anyway, 'cause Taker won't just lie down for nobody.
I watched the angle with my family on RAW, and their reaction was "What is with Vince? Haha, why are we just watching him walk for so long?" I told them to keep watching, then he got in his limo and BOOM! My dad started laughing hysterically, as did I, and my nephew was kind of scared by it all. He knows it's all fake, but he was under the belief Santino Marella was actually a fan, and was disappointed when he found out otherwise. There was some markish fear in him, and he couldn't understand why his uncle and grandfather were laughing.
Then my dad started to get into it, and asked me all these questions. "Why did Vince go crazy? Is he actually dying, and he just decided to go out with a bang? Is he leaving the company to his son?" Then he asked me something that made me completely question his sanity: "Are you sure he's not actually dying, because it didn't look like a stuntman?"

No, he actually decided to blow himself up for RAW. My dad is pretty crafty onto things, he knows when wrestlers aren't going to fight ("You know he's not going to do anything, because he's still wearing his watch"). I think this is just something that is alluring people's creativity.
I think even those who realise that wrestling is fixed are at least slightly interested in where this is going. If the WWE has it revealed to be someone the fans can instantly latch on to, and can expect to be around for some time (ie. non-Jackass guys), the WWE could have one of its hottest angles on its hands.