The site is totally unusable right now unless you're a paid subscriber, in which case it's only very slightly less unusable - so by definition I'd say yeah, Twitter as we knew it has been destroyed. Whether Elon intends to backpedal in the next 12-24 hours as seems to be his MO remains to be seen.