Actually, density is the most important factor contributing to tone, followed by the cellular structure of the wood. The denser the wood, the more sustain. The Tiger, for instance, is made of cocobolo rosewood, a very dense and heavy wood, therefore, it has great sustain, in addition to a ringing, bright and seperated tone. Softer woods, however, contribute warmth, ie, pre-war Martin acoustics with eastern red cedar tops ( a light, yet strong wood) that have wonderful warm tone. Rosewood is a denser wood than maple, therefore, in theory, it will contribute more sustain.
However, there are more factors contribuiting to tone than just the wood of the top. The join of the neck (bolt on, set neck, or neck through) determines how well sound is transferred. A shorter scale length will have poorer sustain than a longer scale length.
Basically, the factors contributing to a guitar's tone are near limitless, choice of top wood is only a small part.