Tony's fate was not made explicit and that was clearly by design. Many theories hold that he was about to be assassinated, but if that was a forgone conclusion, why not depict it?
My personal feeling is that the message is, while Tony may not necessarily die today, his life will always be in some degree of peril because of his career, a wise guy Sword of Damocles.
The same goes for his immediate family, Tony Jr. in particular. Meadow's absence, also clearly by design, is probably an indication that she has the potential to get out of the cycle of crime and violence.