You should use an antenna that is designed for the frequency of your RF module unless you have a compelling reason to choose a different antenna. A properly designed antenna will make the best use of the RF module's output power and avoid damage to the RF module.
If you decide to use an antenna designed for a different frequency range from the RF module, you should probably design and insert an impedance-matching network between the RF module and the antenna to protect the RF module from power reflected by the mismatched antenna. Here's an example from the datasheet for a PCB-mounted chip antenna:

The chip antenna is the 4.5-mm x 13-mm rectangle on the right-hand side of the diagram. The black rectangles in the "Matching Circuit" are surface-mount (SMT) inductors and/or capacitors in a $\pi$-network configuration. The rectangle at the bottom of the "Matching Circuit" is a ground pad with vias that pass through the PCB to make a low-impedance connection to the copper plane on the back side.
Well-known electronic parts distributors sell a variety of monopole, helical monopole, dipole, patch and chip antennas that might work in your application. Your antenna of choice must survive high acceleration in atmosphere and add as little drag as possible to the rocket assembly. The size, shape and mounting arrangement will all be important. An antenna with very low gain (large negative dB value) and/or low efficiency will not radiate the signal from the RF module as well as an antenna with more gain and higher efficiency.
The application notes section of the Linx Technologies web page contains numerous useful documents with which you could educate yourself. I refer you, in particular to AN-00501: Understanding Antenna Specifications and Operation, which discusses all of the important factors you need to consider when choosing your antenna.
I provide the links only as examples of your antenna options. I am not affiliated with any distributor or manufacturer.