The explosion was very expected.
"Falcon 9 will likely break apart due to aerodynamic loads immediately following Crew Dragon's escape"
https://www.reddit.com/r/spacex/comments/eq24ap/rspacex_infl...
https://www.reddit.com/r/spacex/comments/eq24ap/rspacex_infl...
Nothing I've seen or heard yet suggests that the test experience was outside expectations.
As far as I know the AFTS consists of a detonating cord that runs along the tanks for fuel and oxidizer and rips them open when triggered. The substances mix and deflagrate and only the massive parts will actually reach ground (or sea).