The main difference is in intention and structural integrity. Say a project is being carried out by two groups, one with a charismatic leader and one with a transformational leader. Each team starts out well with much energy and enthusiasm. The charismatic leader just decides one day to leave and go elsewhere. The likely result is the charismatic team's project will stall out or fail altogether to achieve the goal. This is because the mental part of achieving success lies with the leader being there. Without that person accomplishment is not possible. With the transformational leader the followers are inspired to believe more in the team and themselves, as well as the goals of the project. If the leader leaves it is likely a new one will step into place and the work will continue until completion.
Based on the comparisons of each style it would seem that overall transformational leadership is better than charismatic. It can be seen how people react with enthusiasm to both types although the goals are more likely to be achieved with transformational than charismatic. Charismatic leadership success depends almost solely on the presence of the leader and can be subject to corruption as the leader knows that the people will likely follow no matter what.