There are three versions talked about
1) Base model with a fan for downforce - no gas thrusters at all. This is the one that may actually ship (but bear in mind the last Roadster prototype he announced was 10 years ago, and that one never did ship)
2) One with a smaller compressed air tank in the trunk and rear facing thrusters that would give you a 0-60 < 1 sec launch mode. This will obviously never be street legal (you can't lay down a "smoke" screen on a public road), but conceivably he may build it if there is enough demand (but read the fine print - it says no guarantee it will ever ship)
3) The on-stage stunt version that can hover and flip, which consumes the entire passenger area with another much larger compressed air tank, and adds bottom and side thrusters to give you ~3 seconds of "flight". "Invite only". Maybe he'll sell one to SpaceX - unmanned operation only - just to say that he did.
Yes, the thruster versions both operate on compressed air, which is why you only get a few seconds of operation.