I've now had close to a week of ego death experience (the orienting center point that the ego needs to exist could not be found, it was diffused into a small mass of emptyness) in total. It's really not that different in terms of activity from having an ego in my experience. The difference is (1) you're not identifying with any of the action, it feels spontaneous, and as a consequence of that (2) the self-consciousness that existed in the ego state is gone, so all kinds of thoughts, positive, negative, indifferent happen as before, but there's no ego to get sucked into their narrative. You're not drowning in them, there's a dam rerouting them.
So I don't think there's anything to be afraid of. Your body goes on as before. Motivations are largely a consequence of physical processes: fears, desires, needs, etc. If you had them before there's no reason you should lose them.
Another benefit of ego death that many people are unaware of is that you can't really process some of your psychological issues until you reach the initial stages of enlightenment (i.e. localized no-self and cosmic self.) This is supposedly when a lot of purification occurs, and people act out. Leo has a video on Zen Devils - I think that's an example of this phenomenon. Fortunately, unless you're in a position of power over people, you are not likely to make a mess of things.