Ok so here’s how I did it in my end. See if this works on you.
My animation is Dash with root motion. Meaning, the animation drives the character’s movement dashing forward so I didn’t need to do the LaunchCharacter node.
[YouTube video of Collision Off/On in action][1]
Below is my Dash animation with root motion:
Then below is my AnimBP that disables and re-enables my collision. They are carefully timed so they are not too short (which might ignore the disabling of collision) nor too far (which too long enough the player will fall through floor). I set the Movement Mode to Flying so my Character will ignore the gravity and avoid falling through floor, but still able to pass through objects due to having no collision. Also note that SetActorEnableCollision has similar result with SetCollisionEnabled. Its just neater not to get the CapsuleComponent node and pass it to SetCollisionEnabled.