@Sunny27 - I watch those caking making shows too and I am always terrified that they will drop the cake or run out of cake supplies in the middle. I think that this would be a really fun career especially is you have an artistic bent because making these cake masterpieces is very similar to sculpting because you are forming an piece based on your artistic vision.
The only difference is that this sculpture is edible. I know that lot of these famous bakeries offer cake decorating classes and some even offer internships. I also know that some cake decorators like artists specialize in different types of materials when baking and decorating. If they are successful, many of these cakes can start at $200 and go into the thousands for a larger event.
I know one famous cake decorator charges $100 just for the consultation in order to determine what the customer wants in terms of the cake.