On a Mexican Riviera cruise in October you will find a pretty good mix of all the above, with maybe slightly more, as you say, middle aged. Not too many elderly and not too many kids. A nice mix.
The cruise line will have somewhat to do with it also. Holland America will be a little older mix; Carnival, a little younger.